Database Queries 219 Queries Logged 44.3 ms 57 duplicate found! 2 duplicates: #5 #6 2 duplicates: #7 #13 2 duplicates: #35 #185 2 duplicates: #45 #56 5 duplicates: #48 #50 #53 #54 #55 7 duplicates: #65 #66 #67 #68 #69 #121 #122 2 duplicates: #76 #78 4 duplicates: #81 #83 #167 #169 2 duplicates: #82 #168 4 duplicates: #94 #96 #181 #183 2 duplicates: #95 #182 4 duplicates: #98 #99 #177 #178 2 duplicates: #119 #125 3 duplicates: #143 #144 #145 3 duplicates: #148 #149 #150 3 duplicates: #153 #154 #155 2 duplicates: #179 #180 3 duplicates: #204 #206 #208 3 duplicates: #205 #207 #209 1. Query Time: 0.35 ms Query memory: 0.014 MB Memory before query: 3.924 MB Rows returned: 1 2. SELECT `data` 3. FROM `sda_session` WHERE `session_id` = 'b5o83j6bk8nr5v2n2hr92lmmq2' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_session const PRIMARY PRIMARY 602 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/session/storage/database.php:46 JROOT/libraries/joomla/session/session.php:658 JROOT/libraries/joomla/session/session.php:596 JROOT/libraries/cms/application/cms.php:672 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/site.php:63 JROOT/libraries/cms/application/cms.php:332 JROOT/libraries/joomla/factory.php:124 JROOT/index.php:37 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 4. Query Time: 1.60 ms After last query: 5.37 ms Query memory: 0.010 MB Memory before query: 4.608 MB Rows returned: 131 5. SELECT folder AS type, element AS name, params 6. FROM sda_extensions 7. WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3) ORDER BY ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_extensions ref extension extension 62 const 157 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/plugin/helper.php:312 JROOT/libraries/cms/plugin/helper.php:165 JROOT/libraries/cms/application/site.php:544 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 8. Query Time: 0.52 ms After last query: 2.38 ms Query memory: 0.013 MB Memory before query: 4.907 MB Rows returned: 1 9. SELECT extension_id AS id, element AS "option", params, enabled 10. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_languages' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/component/helper.php:395 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:91 JROOT/libraries/cms/application/site.php:597 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 11. Query Time: 0.50 ms After last query: 5.01 ms Query memory: 0.017 MB Memory before query: 5.332 MB Rows returned: 1 12. SELECT extension_id AS id, element AS "option", params, enabled 13. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_kunena' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/component/helper.php:395 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:73 JROOT/plugins/system/kunena/kunena.php:26 JROOT/libraries/cms/plugin/helper.php:257 JROOT/libraries/cms/plugin/helper.php:172 JROOT/libraries/cms/application/cms.php:586 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 14. Query Time: 0.21 ms After last query: 14.69 ms Query memory: 0.012 MB Memory before query: 7.290 MB Rows returned: 1 Duplicate queries: #6 SELECT `enabled` FROM `sda_extensions` WHERE `element` = 'com_akeeba' AND `type` = 'component' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/srp/srp.php:47 JROOT/libraries/cms/plugin/helper.php:232 JROOT/libraries/cms/plugin/helper.php:172 JROOT/libraries/cms/application/cms.php:586 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 15. Query Time: 0.13 ms After last query: 4.36 ms Query memory: 0.012 MB Memory before query: 7.870 MB Rows returned: 1 Duplicate queries: #5 SELECT `enabled` FROM `sda_extensions` WHERE `element` = 'com_akeeba' AND `type` = 'component' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/backuponupdate/backuponupdate.php:61 JROOT/libraries/cms/plugin/helper.php:232 JROOT/libraries/cms/plugin/helper.php:172 JROOT/libraries/cms/application/cms.php:586 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 16. Query Time: 0.21 ms After last query: 14.00 ms Query memory: 0.016 MB Memory before query: 9.472 MB Rows returned: 1 Duplicate queries: #13 SELECT `value` FROM `sda_admintools_storage` WHERE `key` = 'cparams' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_admintools_storage const PRIMARY PRIMARY 767 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_admintools/models/storage.php:70 JROOT/administrator/components/com_admintools/models/storage.php:38 JROOT/plugins/system/admintools/admintools/core.php:89 JROOT/plugins/system/admintools/admintools/main.php:48 JROOT/libraries/cms/plugin/helper.php:257 JROOT/libraries/cms/plugin/helper.php:172 JROOT/libraries/cms/application/cms.php:586 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 17. Query Time: 0.20 ms After last query: 7.85 ms Query memory: 0.015 MB Memory before query: 10.655 MB Rows returned: 0 18. SELECT `query` 19. FROM `sda_admintools_wafexceptions` 20. WHERE (`option` IS NULL OR `option` = '') AND (`view` IS NULL OR `view` = '') 21. GROUP BY `query` ORDER BY `query` ASC Explain id select_type table type possible_ keys key key_len ref rows Extra 1 SIMPLE sda_admintools_wafexceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/admintools/admintools/pro.php:3418 JROOT/plugins/system/admintools/admintools/pro.php:69 JROOT/plugins/system/admintools/admintools/main.php:53 JROOT/libraries/cms/plugin/helper.php:257 JROOT/libraries/cms/plugin/helper.php:172 JROOT/libraries/cms/application/cms.php:586 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 22. Query Time: 0.58 ms After last query: 17.24 ms Query memory: 0.019 MB Memory before query: 12.050 MB Rows returned: 1 23. SELECT extension_id AS id, element AS "option", params, enabled 24. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_k2' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/component/helper.php:395 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:91 JROOT/plugins/system/k2/k2.php:433 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 25. Query Time: 0.59 ms After last query: 10.10 ms Query memory: 0.024 MB Memory before query: 13.485 MB Rows returned: 1 26. SELECT extension_id AS id, element AS "option", params, enabled 27. FROM sda_extensions WHERE `type` = 'library' AND `element` = 'joomla' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/library/helper.php:156 JROOT/libraries/cms/library/helper.php:47 JROOT/libraries/cms/library/helper.php:90 JROOT/libraries/cms/version/version.php:179 JROOT/libraries/joomla/factory.php:734 JROOT/libraries/joomla/factory.php:215 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3759 JROOT/plugins/system/k2/k2.php:438 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 28. Query Time: 1.27 ms After last query: 0.50 ms Query memory: 0.019 MB Memory before query: 13.469 MB 29. UPDATE `sda_extensions` 30. SET `params` = '{\"mediaversion\":\"63eeb38db773b8bb88d8bbebb3cda34c\"}' WHERE `type` = 'library' AND `element` = 'joomla' Explain EXPLAIN not possible on query: UPDATE `sda_extensions` SET `params` = '{\"mediaversion\":\"63eeb38db773b8bb88d8bbebb3cda34c\"}' WHERE `type` = 'library' AND `element` = 'joomla' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/library/helper.php:119 JROOT/libraries/cms/version/version.php:230 JROOT/libraries/cms/version/version.php:189 JROOT/libraries/joomla/factory.php:734 JROOT/libraries/joomla/factory.php:215 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3759 JROOT/plugins/system/k2/k2.php:438 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 31. Query Time: 0.14 ms After last query: 26.14 ms Query memory: 0.015 MB Memory before query: 19.124 MB Rows returned: 0 32. SELECT * 33. FROM `sda_admintools_ipautoban` WHERE `ip` = '24.105.196.250' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/admintools/admintools/pro.php:2529 JROOT/plugins/system/admintools/admintools/pro.php:132 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 34. Query Time: 0.12 ms After last query: 0.16 ms Query memory: 0.016 MB Memory before query: 19.138 MB Rows returned: 1 Duplicate queries: #7 SELECT `value` FROM `sda_admintools_storage` WHERE `key` = 'cparams' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_admintools_storage const PRIMARY PRIMARY 767 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_admintools/models/storage.php:70 JROOT/administrator/components/com_admintools/models/storage.php:38 JROOT/plugins/system/admintools/admintools/pro.php:135 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 35. Query Time: 0.19 ms After last query: 21.03 ms Query memory: 0.015 MB Memory before query: 19.168 MB Rows returned: 3 36. SELECT `word` 37. FROM `sda_admintools_badwords` GROUP BY `word` Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_admintools_badwords ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using temporary; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/admintools/admintools/pro.php:895 JROOT/plugins/system/admintools/admintools/pro.php:288 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 38. Query Time: 0.55 ms After last query: 0.50 ms Query memory: 0.015 MB Memory before query: 19.185 MB Rows returned: 0 39. SELECT `source`,`keepurlparams` 40. FROM `sda_admintools_redirects` 41. WHERE (`dest` = 'profile-view/userprofile.html') OR (`dest` = 'profile-view/userprofile.html?tab=getprofilegallerytab') AND `published` = '1' ORDER BY `ordering` DESC LIMIT 0, 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_admintools_redirects ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/admintools/admintools/pro.php:980 JROOT/plugins/system/admintools/admintools/pro.php:300 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 42. Query Time: 0.13 ms After last query: 0.31 ms Query memory: 0.018 MB Memory before query: 19.198 MB Rows returned: 4 43. SELECT * 44. FROM `sda_admintools_storage` WHERE `key` LIKE 'timestamp_%' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_admintools_storage range PRIMARY PRIMARY 767 NULL 4 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/admintools/admintools/pro.php:3490 JROOT/plugins/system/admintools/admintools/pro.php:1849 JROOT/plugins/system/admintools/admintools/pro.php:1036 JROOT/plugins/system/admintools/admintools/pro.php:303 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:587 JROOT/libraries/cms/application/site.php:618 JROOT/libraries/cms/application/site.php:196 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 45. Query Time: 1.04 ms After last query: 4.41 ms Query memory: 0.020 MB Memory before query: 19.479 MB Rows returned: 66 46. SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 47. FROM sda_menu AS m 48. LEFT JOIN sda_extensions AS e ON m.component_id = e.extension_id 49. WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 74 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 cdmasclo.m.component_id 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/menu/site.php:47 JROOT/libraries/cms/menu/menu.php:64 JROOT/libraries/cms/menu/menu.php:118 JROOT/libraries/cms/application/cms.php:357 JROOT/libraries/cms/application/site.php:250 JROOT/libraries/cms/router/site.php:210 JROOT/libraries/cms/router/router.php:391 JROOT/libraries/cms/router/router.php:184 JROOT/libraries/cms/router/site.php:82 JROOT/libraries/cms/application/cms.php:1029 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 50. Query Time: 0.52 ms After last query: 5.82 ms Query memory: 0.027 MB Memory before query: 20.379 MB Rows returned: 4 51. SELECT id, home, template, s.params 52. FROM sda_template_styles as s 53. LEFT JOIN sda_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 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_ clientid 303 cdmasclo.s.template,const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/application/site.php:455 JROOT/libraries/cms/html/html.php:336 JROOT/libraries/cms/html/html.php:682 JROOT/libraries/cms/html/html.php:238 JROOT/libraries/cms/html/html.php:140 JROOT/libraries/cms/html/behavior.php:63 JROOT/libraries/cms/html/behavior.php:60 JROOT/libraries/cms/html/behavior.php:292 JROOT/libraries/cms/html/html.php:238 JROOT/libraries/cms/html/html.php:140 JROOT/plugins/system/k2/k2.php:47 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 54. Query Time: 0.14 ms After last query: 2.94 ms Query memory: 0.019 MB Memory before query: 20.790 MB Rows returned: 1 55. SELECT * 56. FROM sda_languages 57. WHERE published=1 ORDER BY ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/language/helper.php:166 JROOT/libraries/cms/application/site.php:306 JROOT/components/com_k2/helpers/utilities.php:315 JROOT/administrator/components/com_k2/helpers/html.php:56 JROOT/plugins/system/k2/k2.php:55 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 58. Query Time: 0.47 ms After last query: 6.10 ms Query memory: 0.019 MB Memory before query: 21.588 MB Rows returned: 1 59. SELECT extension_id AS id, element AS "option", params, enabled 60. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_aclmanager' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/component/helper.php:395 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:91 JROOT/plugins/system/aclmanager/aclmanager.php:21 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 61. Query Time: 0.13 ms After last query: 0.22 ms Query memory: 0.015 MB Memory before query: 21.563 MB Rows returned: 1 SELECT COUNT(*) FROM sda_rantispam_banip WHERE bannedip = '24.105.196.250' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/rantispam/rantispam.php:85 JROOT/plugins/system/rantispam/rantispam.php:119 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 62. Query Time: 0.19 ms After last query: 4.45 ms Query memory: 0.021 MB Memory before query: 22.553 MB Rows returned: 1 63. SELECT * 64. FROM `sda_cbsubs_config` WHERE `id` = '1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_cbsubs_config const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:76 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidTable.php:150 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidApp.php:64 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:114 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:296 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 65. Query Time: 0.92 ms After last query: 2.12 ms Query memory: 0.031 MB Memory before query: 22.917 MB Rows returned: 15 SHOW FULL COLUMNS FROM `sda_users` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `sda_users` Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/table.php:229 JROOT/libraries/joomla/table/table.php:150 JROOT/libraries/joomla/table/user.php:38 JROOT/libraries/joomla/table/table.php:294 JROOT/libraries/joomla/user/user.php:533 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:691 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:654 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1056 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1014 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:950 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:973 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidUserExtension.php:184 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:229 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:114 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:296 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 66. Query Time: 0.16 ms After last query: 0.67 ms Query memory: 0.024 MB Memory before query: 23.016 MB Rows returned: 1 67. SELECT c.*, u.* 68. FROM sda_users AS u LEFT JOIN sda_comprofiler AS c ON c.id = u.id WHERE u.id = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:783 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:767 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1057 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1014 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:950 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:973 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidUserExtension.php:184 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:229 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:114 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:296 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 69. Query Time: 0.35 ms After last query: 0.36 ms Query memory: 0.031 MB Memory before query: 23.115 MB Rows returned: 1 70. SELECT extension_id AS id, element AS "option", params, enabled 71. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_users' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/component/helper.php:395 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:91 JROOT/libraries/joomla/access/access.php:295 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:816 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:804 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:780 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1057 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1014 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:950 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:973 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidUserExtension.php:184 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:229 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:114 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:296 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 72. Query Time: 0.14 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 23.110 MB Rows returned: 4 73. SELECT a.id 74. FROM sda_user_usergroup_map AS map 75. LEFT JOIN sda_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE map ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 cdmasclo.map.group_id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:336 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:816 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:804 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:780 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1057 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1014 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:950 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:973 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidUserExtension.php:184 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:229 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:114 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:296 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 76. Query Time: 0.15 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 23.113 MB Rows returned: 1 77. SELECT s.* FROM sda_cbsubs_subscriptions s 78. WHERE s.user_id = 1 79. AND s.status = 'A' ORDER BY s.plan_id Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref user_status_plan,status_plan_expiry user_status_plan 7 const,const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:806 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:452 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidTable.php:212 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidUserExtension.php:151 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidUserExtension.php:194 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:229 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:114 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:296 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 80. Query Time: 0.21 ms After last query: 3.35 ms Query memory: 0.025 MB Memory before query: 23.909 MB Rows returned: 1 81. SELECT a.* FROM `sda_cbsubs_plans` AS a WHERE a.`id` = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:806 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:86 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:64 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:51 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/something/cbpaidSomething.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/something/cbpaidSomething.php:189 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/products/usersubscription/cbpaidUsersubscriptionRecord.php:765 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidUserExtension.php:199 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:229 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:114 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:296 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 82. Query Time: 0.24 ms After last query: 3.61 ms Query memory: 0.024 MB Memory before query: 24.812 MB Rows returned: 11 83. SELECT a.* FROM `sda_cbsubs_plans` AS a 84. LEFT JOIN `sda_cbsubs_plans` AS b ON b.`id` = a.`parent` 85. WHERE a.published = 1 AND a.viewaccesslevel IN (1,2,3) 86. GROUP BY a.id ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref published_allownew_allowreg_parent_ordering published_allownew_allowreg_parent_ordering 1 const 10 Using where; Using temporary; Using filesort 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 cdmasclo.a.parent 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:806 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:86 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:139 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:722 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:754 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:538 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1317 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:131 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:141 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:297 JROOT/libraries/joomla/event/dispatcher.php:167 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/cms.php:1038 JROOT/libraries/cms/application/site.php:718 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 87. Query Time: 0.57 ms After last query: 10.84 ms Query memory: 0.014 MB Memory before query: 25.839 MB Rows returned: 1 88. SELECT extension_id AS id, element AS "option", params, enabled 89. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_comprofiler' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/component/helper.php:395 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:91 JROOT/libraries/cms/application/site.php:298 JROOT/libraries/cms/application/site.php:122 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 90. Query Time: 0.26 ms After last query: 7.88 ms Query memory: 0.017 MB Memory before query: 27.675 MB Rows returned: 35 91. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name 92. FROM sda_comprofiler_plugin 93. WHERE published = 1 AND access IN (0,1,2) AND type = 'user' ORDER BY ordering Explain id select_type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ref idx_folder,type_pub_order type_pub_ order 304 const,const 34 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/plugin.class.php:123 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 94. Query Time: 0.15 ms After last query: 58.91 ms Query memory: 0.061 MB Memory before query: 45.914 MB Rows returned: 1 95. SELECT * 96. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbforums' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:78 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:16 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:640 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 97. Query Time: 0.12 ms After last query: 0.21 ms Query memory: 0.061 MB Memory before query: 45.979 MB Rows returned: 1 98. SELECT * 99. FROM `sda_comprofiler_tabs` WHERE `pluginid` = 524 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_tabs ALL NULL NO INDEX KEY NULL NULL 39 Using where COULD BE USED Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:91 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:16 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:640 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 100. Query Time: 0.11 ms After last query: 1.73 ms Query memory: 0.062 MB Memory before query: 46.296 MB Rows returned: 1 SELECT * FROM sda_kunena_configuration WHERE id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_configuration const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/config.php:285 JROOT/libraries/kunena/config.php:239 JROOT/libraries/kunena/factory.php:26 JROOT/libraries/kunena/forum/forum.php:129 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:38 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.class.php:640 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 101. Query Time: 0.22 ms After last query: 31.22 ms Query memory: 0.057 MB Memory before query: 50.603 MB Rows returned: 1 Duplicate queries: #185 SELECT * FROM sda_adsmanager_config Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_adsmanager/lib/core.php:86 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:10 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 102. Query Time: 0.11 ms After last query: 12.05 ms Query memory: 0.056 MB Memory before query: 52.129 MB Rows returned: 1 103. SELECT * 104. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbblogs' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:73 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:24 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:1143 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 105. Query Time: 0.12 ms After last query: 0.27 ms Query memory: 0.055 MB Memory before query: 52.192 MB Rows returned: 1 106. SELECT * 107. FROM `sda_comprofiler_tabs` WHERE `pluginid` = 523 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_tabs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 39 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:86 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:24 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:1143 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 108. Query Time: 0.13 ms After last query: 2.34 ms Query memory: 0.050 MB Memory before query: 52.824 MB Rows returned: 1 109. SELECT * 110. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbautoactions' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:28 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:271 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:831 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 111. Query Time: 0.17 ms After last query: 15.07 ms Query memory: 0.050 MB Memory before query: 57.563 MB Rows returned: 0 112. SELECT * 113. FROM `sda_comprofiler_plugin_autoactions` 114. WHERE ( `published` = 1 ) ORDER BY `ordering` ASC Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:1423 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.class.php:302 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/plugin.cbautoactions.php:4 JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:12 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 115. Query Time: 0.13 ms After last query: 5.30 ms Query memory: 0.034 MB Memory before query: 59.189 MB Rows returned: 8 116. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name 117. FROM sda_comprofiler_plugin 118. WHERE published = 1 AND access IN (0,1,2) AND type = 'user/plug_cbgroupjive/plugins' ORDER BY ordering Explain id select_type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ref idx_folder,type_pub_order type_pub_ order 304 const,const 8 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/plugin.class.php:123 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:1231 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:7771 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 119. Query Time: 0.22 ms After last query: 22.97 ms Query memory: 0.039 MB Memory before query: 67.131 MB Rows returned: 0 120. SELECT * 121. FROM `sda_groupjive_plugin_auto` 122. WHERE ( `published` = 1 ) ORDER BY `ordering` ASC Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveauto/cbgroupjiveauto.php:2293 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveauto/cbgroupjiveauto.php:1917 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveauto/cbgroupjiveauto.php:2326 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:1231 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:7771 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 123. Query Time: 0.15 ms After last query: 2.49 ms Query memory: 0.039 MB Memory before query: 67.831 MB Rows returned: 1 124. SELECT * 125. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbgroupjive' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:30 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveforums/cbgroupjiveforums.php:40 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveforums/cbgroupjiveforums.php:851 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:1231 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:7771 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 126. Query Time: 0.15 ms After last query: 2.04 ms Query memory: 0.039 MB Memory before query: 67.958 MB Rows returned: 1 127. SELECT * 128. FROM `sda_comprofiler_tabs` WHERE `pluginid` = 511 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_tabs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 39 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:43 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveforums/cbgroupjiveforums.php:40 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/plugins/cbgroupjiveforums/cbgroupjiveforums.php:851 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:1231 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:7771 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:9 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:6 JROOT/administrator/components/com_comprofiler/plugin.class.php:219 JROOT/administrator/components/com_comprofiler/plugin.class.php:138 JROOT/components/com_comprofiler/comprofiler.html.php:376 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 129. Query Time: 0.18 ms After last query: 12.78 ms Query memory: 0.018 MB Memory before query: 71.350 MB Rows returned: 7 130. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name 131. FROM sda_comprofiler_plugin 132. WHERE published = 1 AND access IN (0,1,2) AND type = 'templates' ORDER BY ordering Explain id select_type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ref idx_folder,type_pub_order type_pub_ order 304 const,const 7 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/plugin.class.php:123 JROOT/components/com_comprofiler/comprofiler.html.php:498 JROOT/components/com_comprofiler/comprofiler.html.php:383 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 133. Query Time: 0.12 ms After last query: 0.85 ms Query memory: 0.020 MB Memory before query: 71.560 MB Rows returned: 14 Duplicate queries: #56 SELECT * FROM `sda_usergroups` ORDER BY `lft` Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_usergroups ALL NULL NO INDEX KEY COULD BE USED NULL NULL 14 Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:390 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 134. Query Time: 0.12 ms After last query: 0.22 ms Query memory: 0.020 MB Memory before query: 71.603 MB Rows returned: 14 135. SELECT parent.id, parent.lft, parent.rgt 136. FROM sda_usergroups AS parent ORDER BY parent.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE parent index NULL idx_usergroup_nested_set_lookup 8 NULL 14 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:180 JROOT/libraries/joomla/access/access.php:139 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 137. Query Time: 0.73 ms After last query: 1.90 ms Query memory: 0.025 MB Memory before query: 72.075 MB Rows returned: 8 SHOW FULL COLUMNS FROM `sda_assets` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `sda_assets` Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/table.php:229 JROOT/libraries/joomla/table/table.php:150 JROOT/libraries/joomla/table/asset.php:63 JROOT/libraries/joomla/table/table.php:294 JROOT/libraries/joomla/access/access.php:146 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 138. Query Time: 0.11 ms After last query: 0.27 ms Query memory: 0.020 MB Memory before query: 72.120 MB Rows returned: 1 Duplicate queries: #50 #53 #54 #55 SELECT id FROM sda_assets WHERE parent_id = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_assets ref idx_parent_id idx_parent_id 4 const 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/nested.php:1214 JROOT/libraries/joomla/access/access.php:147 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 139. Query Time: 0.10 ms After last query: 0.19 ms Query memory: 0.020 MB Memory before query: 72.144 MB Rows returned: 0 140. SELECT b.rules 141. FROM sda_assets AS a 142. LEFT JOIN sda_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 143. WHERE (a.name = '') 144. GROUP BY b.id, b.rules, b.lft ORDER BY b.lft Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:250 JROOT/libraries/joomla/access/access.php:153 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 145. Query Time: 0.09 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 72.174 MB Rows returned: 1 Duplicate queries: #48 #53 #54 #55 SELECT id FROM sda_assets WHERE parent_id = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_assets ref idx_parent_id idx_parent_id 4 const 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/nested.php:1214 JROOT/libraries/joomla/access/access.php:257 JROOT/libraries/joomla/access/access.php:153 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 146. Query Time: 0.10 ms After last query: 0.23 ms Query memory: 0.020 MB Memory before query: 72.186 MB Rows returned: 1 147. SELECT rules 148. FROM sda_assets WHERE id = '1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_assets const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:263 JROOT/libraries/joomla/access/access.php:153 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 149. Query Time: 0.11 ms After last query: 0.71 ms Query memory: 0.019 MB Memory before query: 72.265 MB Rows returned: 14 150. SELECT b.id 151. FROM sda_user_usergroup_map AS map 152. LEFT JOIN sda_usergroups AS a ON a.id = map.group_id 153. LEFT JOIN sda_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE map.user_id = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE map ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE a eq_ ref PRIMARY PRIMARY 4 cdmasclo.map.group_id 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 14 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:336 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:89 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:711 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 154. Query Time: 0.12 ms After last query: 0.29 ms Query memory: 0.020 MB Memory before query: 72.287 MB Rows returned: 1 Duplicate queries: #48 #50 #54 #55 SELECT id FROM sda_assets WHERE parent_id = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_assets ref idx_parent_id idx_parent_id 4 const 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/nested.php:1214 JROOT/libraries/joomla/access/access.php:147 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 155. Query Time: 0.10 ms After last query: 0.25 ms Query memory: 0.020 MB Memory before query: 72.309 MB Rows returned: 1 Duplicate queries: #48 #50 #53 #55 SELECT id FROM sda_assets WHERE parent_id = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_assets ref idx_parent_id idx_parent_id 4 const 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/nested.php:1214 JROOT/libraries/joomla/access/access.php:147 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 156. Query Time: 0.10 ms After last query: 0.35 ms Query memory: 0.020 MB Memory before query: 72.331 MB Rows returned: 1 Duplicate queries: #48 #50 #53 #54 SELECT id FROM sda_assets WHERE parent_id = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_assets ref idx_parent_id idx_parent_id 4 const 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/nested.php:1214 JROOT/libraries/joomla/access/access.php:147 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:399 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 157. Query Time: 0.11 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 72.344 MB Rows returned: 14 Duplicate queries: #45 SELECT * FROM `sda_usergroups` ORDER BY `lft` Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_usergroups ALL NULL NO INDEX KEY COULD BE USED NULL NULL 14 Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:478 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:412 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:708 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 158. Query Time: 0.12 ms After last query: 0.38 ms Query memory: 0.020 MB Memory before query: 72.392 MB Rows returned: 14 159. SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level 160. FROM `sda_usergroups` AS a 161. LEFT JOIN `sda_usergroups` AS b ON a.`lft` > b.`lft` AND a.`rgt` < b.`rgt` 162. GROUP BY a.`id` ORDER BY a.`lft` ASC Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 14 Using temporary; Using filesort 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 14 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:160 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:727 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1104 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:1155 JROOT/components/com_comprofiler/comprofiler.html.php:385 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 163. Query Time: 0.15 ms After last query: 1.95 ms Query memory: 0.021 MB Memory before query: 72.661 MB Rows returned: 37 164. SELECT * FROM sda_comprofiler_tabs t 165. WHERE t.enabled=1 166. AND t.viewaccesslevel IN (1,2,3) 167. AND t.useraccessgroupid IN (-2,-1,1,9,6,7,2,12,3,4,5,13,10,14,11,8) ORDER BY t.position, t.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ref enabled_position_ordering,orderreg_enabled_pos_order enabled_position_ordering 1 const 36 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3303 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3327 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 168. Query Time: 0.16 ms After last query: 2.52 ms Query memory: 0.025 MB Memory before query: 72.950 MB Rows returned: 1 169. SELECT * 170. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbconnect' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbconnect/cbconnect.class.php:17 JROOT/components/com_comprofiler/plugin/user/plug_cbconnect/plugin.cbconnect.php: 39 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:541 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3331 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 171. Query Time: 0.13 ms After last query: 1.32 ms Query memory: 0.027 MB Memory before query: 73.043 MB Rows returned: 7 172. SELECT a.* 173. FROM `sda_comprofiler_plugin_antispam_log` AS a 174. WHERE ( a.`user_id` = 1 ) ORDER BY a.`date` DESC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref user_id user_id 4 const 7 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:3305 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:997 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:953 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/plugin.cbantispam.php:548 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:541 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3331 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 175. Query Time: 0.12 ms After last query: 0.36 ms Query memory: 0.026 MB Memory before query: 73.087 MB Rows returned: 0 176. SELECT a.* 177. FROM `sda_comprofiler_plugin_antispam_whitelist` AS a 178. WHERE ( a.`type` = 'user' ) AND ( a.`value` = 1 ) OR ( ( a.`type` = 'email' ) AND ( a.`value` = 'allenjj@mhcable.com' ) ) OR ( ( a.`type` = 'ip' ) AND ( a.`value` = '24.105.196.250' ) ) OR ( ( a.`type` = 'domain' ) AND ( a.`value` = 'mhcable.com' ) ) ORDER BY a.`date` DESC Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:3212 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:971 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/plugin.cbantispam.php:548 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:541 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3331 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 179. Query Time: 0.11 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 73.105 MB Rows returned: 1 180. SELECT * 181. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbantispam' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:25 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/plugin.cbantispam.php:50 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/plugin.cbantispam.php:550 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:541 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3331 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 182. Query Time: 0.09 ms After last query: 0.60 ms Query memory: 0.026 MB Memory before query: 73.158 MB Rows returned: 1 183. SELECT * 184. FROM `sda_comprofiler_tabs` WHERE `pluginid` = 521 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_tabs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 39 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.class.php:38 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/plugin.cbantispam.php:50 JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/plugin.cbantispam.php:550 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:541 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3331 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 185. Query Time: 0.09 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 73.199 MB Rows returned: 2 SELECT id FROM sda_menu WHERE link = 'index.php?option=com_comprofiler' AND published = 1 AND access IN (1,2,3) AND `language` IN ( 'en-GB', '*', '' ) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_menu ALL idx_language NO INDEX KEY COULD BE USED NULL NULL 191 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:756 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:69 JROOT/components/com_comprofiler/plugin/user/plug_cbmenu/cb.menu.php:968 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3354 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 186. Query Time: 0.11 ms After last query: 1.62 ms Query memory: 0.023 MB Memory before query: 73.272 MB Rows returned: 4 Duplicate queries: #66 #67 #68 #69 #121 #122 SELECT g.id AS gid FROM (sda_users AS u INNER JOIN sda_user_usergroup_map AS um ON u.id=um.user_id) INNER JOIN sda_usergroups AS g ON um.group_id=g.id WHERE u.id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE um ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cdmasclo.um.group_id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_uddeim/uddeimlib32.php:356 JROOT/components/com_comprofiler/plugin/user/plug_privatemessagingsystem(uddeimpms)/pms.uddeim.php:73 JROOT/administrator/components/com_comprofiler/plugin.class.php:250 JROOT/administrator/components/com_comprofiler/plugin.class.php:576 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3354 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 187. Query Time: 0.08 ms After last query: 0.39 ms Query memory: 0.023 MB Memory before query: 73.324 MB Rows returned: 4 Duplicate queries: #65 #67 #68 #69 #121 #122 SELECT g.id AS gid FROM (sda_users AS u INNER JOIN sda_user_usergroup_map AS um ON u.id=um.user_id) INNER JOIN sda_usergroups AS g ON um.group_id=g.id WHERE u.id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE um ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cdmasclo.um.group_id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_uddeim/uddeimlib32.php:356 JROOT/components/com_comprofiler/plugin/user/plug_uddeimprofilelink/pms.uddeim.profilelink.php:64 JROOT/administrator/components/com_comprofiler/plugin.class.php:250 JROOT/administrator/components/com_comprofiler/plugin.class.php:576 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3354 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 188. Query Time: 0.15 ms After last query: 6.50 ms Query memory: 0.023 MB Memory before query: 73.941 MB Rows returned: 4 Duplicate queries: #65 #66 #68 #69 #121 #122 SELECT g.id AS gid FROM (sda_users AS u INNER JOIN sda_user_usergroup_map AS um ON u.id=um.user_id) INNER JOIN sda_usergroups AS g ON um.group_id=g.id WHERE u.id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE um ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cdmasclo.um.group_id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_uddeim/uddeimlib32.php:356 JROOT/components/com_comprofiler/plugin/user/plug_uddeimblockingplugin/blocking. uddeim.php:69 JROOT/administrator/components/com_comprofiler/plugin.class.php:250 JROOT/administrator/components/com_comprofiler/plugin.class.php:576 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3354 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 189. Query Time: 0.12 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 73.989 MB Rows returned: 4 Duplicate queries: #65 #66 #67 #69 #121 #122 SELECT g.id AS gid FROM (sda_users AS u INNER JOIN sda_user_usergroup_map AS um ON u.id=um.user_id) INNER JOIN sda_usergroups AS g ON um.group_id=g.id WHERE u.id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE um ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cdmasclo.um.group_id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_uddeim/uddeimlib32.php:356 JROOT/components/com_comprofiler/plugin/user/plug_pmsuddeiminbox/pms.showinbox.php:71 JROOT/administrator/components/com_comprofiler/plugin.class.php:250 JROOT/administrator/components/com_comprofiler/plugin.class.php:576 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3354 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 190. Query Time: 0.10 ms After last query: 1.17 ms Query memory: 0.023 MB Memory before query: 74.121 MB Rows returned: 4 Duplicate queries: #65 #66 #67 #68 #121 #122 SELECT g.id AS gid FROM (sda_users AS u INNER JOIN sda_user_usergroup_map AS um ON u.id=um.user_id) INNER JOIN sda_usergroups AS g ON um.group_id=g.id WHERE u.id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE um ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cdmasclo.um.group_id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_uddeim/uddeimlib32.php:356 JROOT/components/com_uddeim/uddeimlib32.php:374 JROOT/components/com_comprofiler/plugin/user/plug_privatemessagingsystem(uddeimpms)/pms.uddeim.php:414 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 191. Query Time: 0.10 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 74.142 MB Rows returned: 27 192. SELECT `id` 193. FROM `sda_menu` WHERE `link` LIKE '%com_kunena%' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 191 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:756 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:1102 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:30 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 194. Query Time: 1.25 ms After last query: 2.18 ms Query memory: 0.041 MB Memory before query: 74.681 MB Rows returned: 38 SHOW FULL COLUMNS FROM `sda_kunena_users` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `sda_kunena_users` Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/table.php:229 JROOT/libraries/joomla/table/table.php:150 JROOT/libraries/kunena/tables/kunenausers.php:238 JROOT/libraries/joomla/table/table.php:294 JROOT/libraries/kunena/user/user.php:138 JROOT/libraries/kunena/user/user.php:159 JROOT/libraries/kunena/user/user.php:82 JROOT/libraries/kunena/user/helper.php:35 JROOT/libraries/kunena/user/helper.php:13 JROOT/libraries/loader.php:540 JROOT/libraries/loader.php:507 JROOT/libraries/kunena/user/user.php:97 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:1034 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:127 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 195. Query Time: 0.12 ms After last query: 0.43 ms Query memory: 0.035 MB Memory before query: 74.794 MB Rows returned: 1 196. SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* 197. FROM sda_users AS u 198. LEFT JOIN sda_kunena_users AS ku ON u.id = ku.userid WHERE u.id = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE ku const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenausers.php:265 JROOT/libraries/kunena/user/user.php:162 JROOT/libraries/kunena/user/user.php:82 JROOT/libraries/kunena/user/helper.php:35 JROOT/libraries/kunena/user/helper.php:13 JROOT/libraries/loader.php:540 JROOT/libraries/loader.php:507 JROOT/libraries/kunena/user/user.php:97 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:1034 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:127 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 199. Query Time: 0.17 ms After last query: 3.12 ms Query memory: 0.027 MB Memory before query: 75.354 MB Rows returned: 48 SELECT * FROM sda_kunena_categories ORDER BY ordering, name Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_categories ALL NULL NO INDEX KEY COULD BE USED NULL NULL 48 Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/category/helper.php:590 JROOT/libraries/kunena/forum/category/helper.php:36 JROOT/libraries/kunena/user/user.php:464 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 200. Query Time: 1.06 ms After last query: 4.87 ms Query memory: 0.035 MB Memory before query: 76.310 MB Rows returned: 32 SHOW FULL COLUMNS FROM `sda_kunena_categories` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `sda_kunena_categories` Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/table.php:229 JROOT/libraries/joomla/table/table.php:150 JROOT/libraries/kunena/tables/kunenacategories.php:54 JROOT/libraries/joomla/table/table.php:294 JROOT/libraries/kunena/database/object.php:230 JROOT/libraries/kunena/database/object.php:78 JROOT/libraries/kunena/forum/category/category.php:631 JROOT/libraries/kunena/forum/category/helper.php:53 JROOT/libraries/kunena/user/user.php:464 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 201. Query Time: 0.10 ms After last query: 0.36 ms Query memory: 0.025 MB Memory before query: 76.403 MB Rows returned: 10 SELECT * FROM sda_kunena_ranks Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_ranks ALL NULL NO INDEX KEY COULD BE USED NULL NULL 10 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/user/user.php:470 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 202. Query Time: 0.11 ms After last query: 2.88 ms Query memory: 0.033 MB Memory before query: 76.846 MB Rows returned: 2 Duplicate queries: #78 SELECT b.rules FROM sda_assets AS a LEFT JOIN sda_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_kunena') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 167 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:250 JROOT/plugins/kunena/joomla/access.php:374 JROOT/plugins/kunena/joomla/access.php:190 JROOT/libraries/kunena/access.php:85 JROOT/libraries/kunena/access.php:59 JROOT/libraries/kunena/access.php:66 JROOT/libraries/kunena/user/user.php:291 JROOT/libraries/kunena/user/user.php:494 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 203. Query Time: 0.15 ms After last query: 0.24 ms Query memory: 0.033 MB Memory before query: 76.888 MB Rows returned: 1 204. SELECT DISTINCT(user_id) 205. FROM sda_usergroups as ug1 206. INNER JOIN sda_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt 207. INNER JOIN sda_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id IN (8) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ug1 const PRIMARY,idx_usergroup_nested_set_lookup PRIMARY 4 const 1 Using temporary 1 SIMPLE ug2 range PRIMARY,idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index 1 SIMPLE m index NULL PRIMARY 8 NULL 43 Using where; Using index; Using join buffer Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/kunena/joomla/access.php:356 JROOT/plugins/kunena/joomla/access.php:397 JROOT/plugins/kunena/joomla/access.php:190 JROOT/libraries/kunena/access.php:85 JROOT/libraries/kunena/access.php:59 JROOT/libraries/kunena/access.php:66 JROOT/libraries/kunena/user/user.php:291 JROOT/libraries/kunena/user/user.php:494 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 208. Query Time: 0.14 ms After last query: 0.21 ms Query memory: 0.033 MB Memory before query: 76.912 MB Rows returned: 2 Duplicate queries: #76 SELECT b.rules FROM sda_assets AS a LEFT JOIN sda_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_kunena') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 Using temporary; Using filesort 1 SIMPLE b ALL idx_lft_rgt NO INDEX KEY COULD BE USED NULL NULL 167 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/access/access.php:250 JROOT/plugins/kunena/joomla/access.php:374 JROOT/plugins/kunena/joomla/access.php:190 JROOT/libraries/kunena/access.php:85 JROOT/libraries/kunena/access.php:59 JROOT/libraries/kunena/access.php:66 JROOT/libraries/kunena/user/user.php:291 JROOT/libraries/kunena/user/user.php:494 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 209. Query Time: 0.13 ms After last query: 0.23 ms Query memory: 0.033 MB Memory before query: 76.954 MB Rows returned: 4 210. SELECT DISTINCT(user_id) 211. FROM sda_usergroups as ug1 212. INNER JOIN sda_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt 213. INNER JOIN sda_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id IN (7) Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE ug1 const PRIMARY,idx_usergroup_ nested_set_lookup PRIMARY 4 const 1 Using temporary 1 SIMPLE m index NULL PRIMARY 8 NULL 43 Using index 1 SIMPLE ug2 eq_ ref PRIMARY,idx_usergroup_ nested_set_lookup PRIMARY 4 cdmasclo.m. group_id 1 Using where; Distinct Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/kunena/joomla/access.php:356 JROOT/plugins/kunena/joomla/access.php:397 JROOT/plugins/kunena/joomla/access.php:190 JROOT/libraries/kunena/access.php:85 JROOT/libraries/kunena/access.php:59 JROOT/libraries/kunena/access.php:66 JROOT/libraries/kunena/user/user.php:291 JROOT/libraries/kunena/user/user.php:494 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 214. Query Time: 0.14 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 76.971 MB Rows returned: 5 SELECT user_id, category_id, role FROM sda_kunena_user_categories WHERE role IN (1,2) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_user_categories index role role 1 NULL 5 Using where; Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/access.php:92 JROOT/libraries/kunena/access.php:59 JROOT/libraries/kunena/access.php:66 JROOT/libraries/kunena/user/user.php:291 JROOT/libraries/kunena/user/user.php:494 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:180 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:248 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 215. Query Time: 0.30 ms After last query: 4.16 ms Query memory: 0.024 MB Memory before query: 77.409 MB Rows returned: 1 Duplicate queries: #83 #167 #169 SELECT COUNT(*) FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages_text AS t ON m.id = t.mesid WHERE m.moved=0 AND m.catid IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND m.hold=0 AND m.userid='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPL m ref PRIMARY,userid,catid_p userid 4 const 10 Using w E arent,hold here 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 cdmasclo. m.id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/message/helper.php:193 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:586 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:303 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 216. Query Time: 0.12 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 77.433 MB Rows returned: 10 Duplicate queries: #168 SELECT m.*, t.message FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages_text AS t ON m.id = t.mesid WHERE m.moved=0 AND m.catid IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND m.hold=0 AND m.userid='1' ORDER BY m.time DESC LIMIT 0, 20 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,userid,catid_parent,hold userid 4 const 10 Using where; Using filesort 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 cdmasclo. m.id 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/message/helper.php:201 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:586 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:303 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 217. Query Time: 0.08 ms After last query: 2.36 ms Query memory: 0.024 MB Memory before query: 77.835 MB Rows returned: 1 Duplicate queries: #81 #167 #169 SELECT COUNT(*) FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages_text AS t ON m.id = t.mesid WHERE m.moved=0 AND m.catid IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND m.hold=0 AND m.userid='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,userid,catid_parent,hold userid 4 const 10 Using where 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 cdmasclo. m.id 1 Using index Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/message/helper.php:193 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:718 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 218. Query Time: 0.13 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 77.859 MB Rows returned: 10 219. SELECT m.*, t.message 220. FROM sda_kunena_messages AS m 221. INNER JOIN sda_kunena_messages_text AS t ON m.id = t.mesid 222. WHERE m.moved=0 AND m.catid IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND m.hold=0 AND m.userid='1' ORDER BY m.`time` DESC LIMIT 0, 10 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,userid,catid_parent,hold userid 4 const 10 Using where; Using filesort 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 cdmasclo. m.id 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/message/helper.php:201 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:718 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 223. Query Time: 0.96 ms After last query: 2.95 ms Query memory: 0.034 MB Memory before query: 78.485 MB Rows returned: 23 SHOW FULL COLUMNS FROM `sda_kunena_topics` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `sda_kunena_topics` Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/table/table.php:229 JROOT/libraries/joomla/table/table.php:150 JROOT/libraries/kunena/tables/kunenatopics.php:45 JROOT/libraries/joomla/table/table.php:294 JROOT/libraries/kunena/database/object.php:230 JROOT/libraries/kunena/database/object.php:78 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 224. Query Time: 0.10 ms After last query: 0.28 ms Query memory: 0.028 MB Memory before query: 78.563 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 35 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 225. Query Time: 0.07 ms After last query: 0.32 ms Query memory: 0.028 MB Memory before query: 78.598 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 33 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 226. Query Time: 0.11 ms After last query: 0.33 ms Query memory: 0.028 MB Memory before query: 78.634 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 18 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 227. Query Time: 0.11 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 78.669 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 17 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 228. Query Time: 0.13 ms After last query: 0.33 ms Query memory: 0.028 MB Memory before query: 78.705 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 19 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 229. Query Time: 0.11 ms After last query: 0.33 ms Query memory: 0.028 MB Memory before query: 78.741 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 10 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 230. Query Time: 0.11 ms After last query: 0.32 ms Query memory: 0.028 MB Memory before query: 78.776 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 2 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 231. Query Time: 0.10 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 78.811 MB Rows returned: 1 SELECT * FROM sda_kunena_topics WHERE id = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_kunena_topics const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/tables/kunenatopics.php:69 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/topic/topic.php:676 JROOT/libraries/kunena/forum/topic/helper.php:40 JROOT/libraries/kunena/forum/message/message.php:323 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:723 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:325 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 232. Query Time: 0.15 ms After last query: 15.01 ms Query memory: 0.024 MB Memory before query: 79.655 MB Rows returned: 1 Duplicate queries: #96 #181 #183 SELECT COUNT(*) FROM sda_kunena_user_topics AS ut INNER JOIN sda_kunena_topics AS tt ON tt.id=ut.topic_id WHERE tt.hold IN (0) AND tt.category_id IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND ut.user_id='1' AND (ut.subscribed=1) AND tt.last_post_time>'-1' AND tt.moved_id='0' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE ut ref user_topic_id,topic_id,subscribed user_topic_id 4 const 10 Using where 1 SIMPLE tt eq_ ref PRIMARY,category_id,hold,last_post_time PRIMARY 4 cdmasclo.ut.topic_id 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:757 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:346 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 233. Query Time: 0.15 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 79.679 MB Rows returned: 8 Duplicate queries: #182 SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread FROM sda_kunena_user_topics AS ut INNER JOIN sda_kunena_topics AS tt ON tt.id=ut.topic_id WHERE tt.hold IN (0) AND tt.category_id IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23 ,13,14,24,25,26,27,28,29) AND ut.user_id='1' AND (ut.subscribed=1) AND tt.last_post_time>'-1' AND tt.moved_id='0' ORDER BY tt.last_post_time DESC LIMIT 0, 20 Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE ut ref user_topic_id,topic_id,subscribed user_topic_id 4 const 10 Using where; Using temporary; Using filesort 1 SIMPLE tt eq_ ref PRIMARY,category_id,hold,last_post_time PRIMARY 4 cdmasclo.ut. topic_id 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/topic/helper.php:238 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:757 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:346 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 234. Query Time: 0.11 ms After last query: 0.63 ms Query memory: 0.024 MB Memory before query: 79.754 MB Rows returned: 1 Duplicate queries: #94 #181 #183 SELECT COUNT(*) FROM sda_kunena_user_topics AS ut INNER JOIN sda_kunena_topics AS tt ON tt.id=ut.topic_id WHERE tt.hold IN (0) AND tt.category_id IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND ut.user_id='1' AND (ut.subscribed=1) AND tt.last_post_time>'-1' AND tt.moved_id='0' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE ut ref user_topic_id,topic_id,subscribed user_topic_id 4 const 10 Using where 1 SIMPLE tt eq_ ref PRIMARY,category_id,hold,last_post_time PRIMARY 4 cdmasclo.ut.topic_id 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:844 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:362 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 235. Query Time: 0.09 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 79.779 MB Rows returned: 8 236. SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread 237. FROM sda_kunena_user_topics AS ut 238. INNER JOIN sda_kunena_topics AS tt ON tt.id=ut.topic_id WHERE tt.hold IN (0) AND tt.category_id IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND ut.user_id='1' AND (ut.subscribed=1) AND tt.last_post_time>'-1' AND tt.moved_id='0' ORDER BY tt.`first_post_time` DESC LIMIT 0, 10 Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE ut ref user_topic_id,topic_id,subscribed user_topic_id 4 const 10 Using where; Using temporary; Using filesort 1 SIMPLE tt eq_ ref PRIMARY,category_id,hold,last_post_time PRIMARY 4 cdmasclo.ut. topic_id 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/topic/helper.php:238 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:844 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:362 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 239. Query Time: 0.12 ms After last query: 8.23 ms Query memory: 0.024 MB Memory before query: 79.817 MB Rows returned: 1 Duplicate queries: #99 #177 #178 SELECT COUNT(*) FROM sda_kunena_user_topics AS ut INNER JOIN sda_kunena_topics AS tt ON tt.id=ut.topic_id WHERE tt.hold IN (0) AND tt.category_id IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND ut.user_id='1' AND (ut.favorite=1) AND tt.last_post_time>'-1' AND tt.moved_id='0' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE ut ref user_topic_id,topic_id,favorite favorite 1 const 1 Using where; Using index 1 SIMPLE tt eq_ ref PRIMARY,category_id,hold,last_post_time PRIMARY 4 cdmasclo.ut.topic_id 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:884 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:380 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 240. Query Time: 0.12 ms After last query: 0.30 ms Query memory: 0.024 MB Memory before query: 79.836 MB Rows returned: 1 Duplicate queries: #98 #177 #178 SELECT COUNT(*) FROM sda_kunena_user_topics AS ut INNER JOIN sda_kunena_topics AS tt ON tt.id=ut.topic_id WHERE tt.hold IN (0) AND tt.category_id IN (31,6,48,16,2,32,7,17,3,33,4,18,8,34,9,19,10,35,20,11,21,36,22,37,12,23,13,14,24,25,26,27,28,29) AND ut.user_id='1' AND (ut.favorite=1) AND tt.last_post_time>'-1' AND tt.moved_id='0' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE ut ref user_topic_id,topic_id,favorite favorite 1 const 1 Using where; Using index 1 SIMPLE tt eq_ ref PRIMARY,category_id,hold,last_post_time PRIMARY 4 cdmasclo.ut.topic_id 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/kunena/forum/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.model.php:971 JROOT/components/com_comprofiler/plugin/user/plug_cbsimpleboardtab/cb.simpleboardtab.php:396 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 241. Query Time: 0.31 ms After last query: 2.53 ms Query memory: 0.028 MB Memory before query: 79.901 MB Rows returned: 1 242. SELECT extension_id AS id, element AS "option", params, enabled 243. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_content' Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/component/helper.php:395 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:91 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2615 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:27 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 244. Query Time: 0.66 ms After last query: 0.40 ms Query memory: 0.024 MB Memory before query: 79.899 MB Rows returned: 10 245. SELECT a.id, a.catid, a.title, a.hits,a.created, ROUND( r.rating_sum / r.rating_count ) AS rating,r.rating_count, 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 246. FROM sda_content AS a 247. LEFT JOIN sda_content_rating AS r ON r.content_id=a.id 248. LEFT JOIN sda_categories AS cc ON cc.id = a.catid 249. WHERE a.created_by=1 250. AND a.state = 1 251. AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2014-02-07 16:02:02') 252. AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2014- 02-07 16:02:02') 253. AND a.access IN (1,2,3) ORDER BY a.created DESC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_access,idx_state,idx_createdby idx_createdby 4 const 10 Using where; Using filesort 1 SIMPLE r eq_ref PRIMARY PRIMARY 4 cdmasclo.a.id 1 1 SIMPLE cc eq_ref PRIMARY PRIMARY 4 cdmasclo.a.catid 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:62 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 254. Query Time: 0.13 ms After last query: 1.57 ms Query memory: 0.025 MB Memory before query: 80.177 MB Rows returned: 2 255. SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 256. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 257. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 258. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 259. FROM sda_categories as c 260. LEFT JOIN sda_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) 261. LEFT JOIN (SELECT cat.id as id FROM sda_categories AS cat JOIN sda_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 262. WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3) AND c.published = 1 AND s.id=32 AND badcats.id is null 263. GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 264. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 265. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 266. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_ left_right NO INDEX KEY COULD BE USED NULL NULL 33 Using where 1 PRIMARY ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Not exists 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 3 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 33 Using where; Using index; Using join buffer Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/legacy/categories/categories.php:288 JROOT/libraries/legacy/categories/categories.php:181 JROOT/components/com_content/helpers/route.php:39 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:118 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 267. Query Time: 0.11 ms After last query: 1.09 ms Query memory: 0.030 MB Memory before query: 80.304 MB Rows returned: 1 268. SELECT alias 269. FROM sda_content WHERE id=11 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 270. Query Time: 0.12 ms After last query: 0.47 ms Query memory: 0.025 MB Memory before query: 80.339 MB Rows returned: 2 271. SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 272. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 273. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 274. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 275. FROM sda_categories as c 276. LEFT JOIN sda_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) 277. LEFT JOIN (SELECT cat.id as id FROM sda_categories AS cat JOIN sda_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 278. WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3) AND c.published = 1 AND s.id=21 AND badcats.id is null 279. GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 280. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 281. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 282. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_ left_right NO INDEX KEY COULD BE USED NULL NULL 33 Using where 1 PRIMARY ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Not exists 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 3 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 33 Using where; Using index; Using join buffer Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/legacy/categories/categories.php:288 JROOT/libraries/legacy/categories/categories.php:181 JROOT/components/com_content/helpers/route.php:39 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:118 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 283. Query Time: 0.11 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 80.368 MB Rows returned: 1 284. SELECT alias 285. FROM sda_content WHERE id=10 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 286. Query Time: 0.15 ms After last query: 0.44 ms Query memory: 0.025 MB Memory before query: 80.403 MB Rows returned: 2 287. SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 288. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 289. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 290. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 291. FROM sda_categories as c 292. LEFT JOIN sda_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) 293. LEFT JOIN (SELECT cat.id as id FROM sda_categories AS cat JOIN sda_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 294. WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3) AND c.published = 1 AND s.id=22 AND badcats.id is null 295. GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 296. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 297. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 298. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_ left_right NO INDEX KEY COULD BE USED NULL NULL 33 Using where 1 PRIMARY ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Not exists 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 3 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 33 Using where; Using index; Using join buffer Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/legacy/categories/categories.php:288 JROOT/libraries/legacy/categories/categories.php:181 JROOT/components/com_content/helpers/route.php:39 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:118 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 299. Query Time: 0.10 ms After last query: 0.36 ms Query memory: 0.030 MB Memory before query: 80.432 MB Rows returned: 1 300. SELECT alias 301. FROM sda_content WHERE id=9 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 302. Query Time: 0.15 ms After last query: 0.44 ms Query memory: 0.025 MB Memory before query: 80.468 MB Rows returned: 2 303. SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 304. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 305. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 306. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 307. FROM sda_categories as c 308. LEFT JOIN sda_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) 309. LEFT JOIN (SELECT cat.id as id FROM sda_categories AS cat JOIN sda_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 310. WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3) AND c.published = 1 AND s.id=20 AND badcats.id is null 311. GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 312. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 313. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 314. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_ left_right NO INDEX KEY COULD BE USED NULL NULL 33 Using where 1 PRIMARY ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Not exists 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 3 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 33 Using where; Using index; Using join buffer Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/legacy/categories/categories.php:288 JROOT/libraries/legacy/categories/categories.php:181 JROOT/components/com_content/helpers/route.php:39 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:118 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 315. Query Time: 0.09 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 80.496 MB Rows returned: 1 316. SELECT alias 317. FROM sda_content WHERE id=8 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 318. Query Time: 0.12 ms After last query: 0.53 ms Query memory: 0.030 MB Memory before query: 80.528 MB Rows returned: 1 319. SELECT alias 320. FROM sda_content WHERE id=7 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 321. Query Time: 0.10 ms After last query: 0.50 ms Query memory: 0.030 MB Memory before query: 80.559 MB Rows returned: 1 322. SELECT alias 323. FROM sda_content WHERE id=6 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 324. Query Time: 0.06 ms After last query: 0.54 ms Query memory: 0.030 MB Memory before query: 80.590 MB Rows returned: 1 325. SELECT alias 326. FROM sda_content WHERE id=5 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 327. Query Time: 0.13 ms After last query: 0.54 ms Query memory: 0.030 MB Memory before query: 80.623 MB Rows returned: 1 328. SELECT alias 329. FROM sda_content WHERE id=4 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 330. Query Time: 0.12 ms After last query: 0.44 ms Query memory: 0.025 MB Memory before query: 80.658 MB Rows returned: 2 331. SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 332. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 333. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 334. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 335. FROM sda_categories as c 336. LEFT JOIN sda_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) 337. LEFT JOIN (SELECT cat.id as id FROM sda_categories AS cat JOIN sda_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 338. WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3) AND c.published = 1 AND s.id=2 AND badcats.id is null 339. GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, 340. c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, 341. c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 342. c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_ left_right NO INDEX KEY COULD BE USED NULL NULL 33 Using where 1 PRIMARY ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Not exists 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 3 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 33 Using where; Using index; Using join buffer Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/legacy/categories/categories.php:288 JROOT/libraries/legacy/categories/categories.php:181 JROOT/components/com_content/helpers/route.php:39 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:118 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 343. Query Time: 0.11 ms After last query: 0.36 ms Query memory: 0.030 MB Memory before query: 80.687 MB Rows returned: 1 344. SELECT alias 345. FROM sda_content WHERE id=3 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 346. Query Time: 0.09 ms After last query: 0.50 ms Query memory: 0.030 MB Memory before query: 80.718 MB Rows returned: 1 347. SELECT alias 348. FROM sda_content WHERE id=2 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_content const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_content/router.php:101 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbmamboauthortab/cb.authortab. php:122 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 349. Query Time: 0.07 ms After last query: 0.34 ms Query memory: 0.022 MB Memory before query: 80.706 MB Rows returned: 1 350. SELECT COUNT(*) 351. FROM sda_comprofiler_members AS m 352. LEFT JOIN sda_comprofiler AS c ON m.memberid=c.id 353. LEFT JOIN sda_users AS u ON m.memberid=u.id 354. WHERE m.referenceid=1 AND c.approved=1 AND c.confirmed=1 AND c.banned=0 AND u.block=0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,membrefid PRIMARY 4 const 1 Using index 1 SIMPLE c eq_ref PRIMARY,apprconfbanid PRIMARY 4 cdmasclo.m.memberid 1 Using where 1 SIMPLE u eq_ref PRIMARY,idx_block PRIMARY 4 cdmasclo.m.memberid 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:756 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:221 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 355. Query Time: 0.10 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 80.729 MB Rows returned: 1 356. SELECT m.*,u.name,u.email,u.username,c.avatar,c.avatarapproved, u.id 357. FROM sda_comprofiler_members AS m 358. LEFT JOIN sda_comprofiler AS c ON m.memberid=c.id 359. LEFT JOIN sda_users AS u ON m.memberid=u.id 360. WHERE m.referenceid=1 361. AND c.approved=1 AND c.confirmed=1 AND c.banned=0 AND u.block=0 ORDER BY m.membersince DESC, m.memberid ASC LIMIT 0, 10 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,membrefid PRIMARY 4 const 1 Using where; Using filesort 1 SIMPLE c eq_ref PRIMARY,apprconfbanid PRIMARY 4 cdmasclo.m.memberid 1 Using where 1 SIMPLE u eq_ref PRIMARY,idx_block PRIMARY 4 cdmasclo.m.memberid 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:235 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 362. Query Time: 0.10 ms After last query: 0.31 ms Query memory: 0.031 MB Memory before query: 80.761 MB Rows returned: 1 Duplicate queries: #125 SELECT username FROM sda_users WHERE id = 5 LIMIT 0, 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_users const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/components/com_comprofiler/router.php:30 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:1416 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:258 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 363. Query Time: 0.10 ms After last query: 0.49 ms Query memory: 0.027 MB Memory before query: 80.789 MB Rows returned: 3 364. SELECT * FROM sda_comprofiler_plugin p 365. WHERE p.published=1 366. AND p.element LIKE '%pms.%' ORDER BY p.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ref idx_folder idx_folder 1 const 61 Using where; Using filesort Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4346 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4383 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:1355 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:260 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 367. Query Time: 0.11 ms After last query: 0.26 ms Query memory: 0.030 MB Memory before query: 80.822 MB Rows returned: 4 Duplicate queries: #65 #66 #67 #68 #69 #122 SELECT g.id AS gid FROM (sda_users AS u INNER JOIN sda_user_usergroup_map AS um ON u.id=um.user_id) INNER JOIN sda_usergroups AS g ON um.group_id=g.id WHERE u.id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE um ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cdmasclo.um.group_id 1 Using index Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/components/com_uddeim/uddeimlib32.php:356 JROOT/components/com_uddeim/includes.db.php:245 JROOT/components/com_comprofiler/plugin/user/plug_privatemessagingsystem(uddeimpms)/pms.uddeim.php:326 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4333 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4353 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4383 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:1355 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:260 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 368. Query Time: 0.09 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 80.852 MB Rows returned: 4 Duplicate queries: #65 #66 #67 #68 #69 #121 SELECT g.id AS gid FROM (sda_users AS u INNER JOIN sda_user_usergroup_map AS um ON u.id=um.user_id) INNER JOIN sda_usergroups AS g ON um.group_id=g.id WHERE u.id=1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE um ref PRIMARY PRIMARY 4 const 4 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cdmasclo.um.group_id 1 Using index Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/components/com_uddeim/uddeimlib32.php:356 JROOT/components/com_uddeim/includes.db.php:274 JROOT/components/com_uddeim/includes.db.php:248 JROOT/components/com_comprofiler/plugin/user/plug_privatemessagingsystem(uddeimpms)/pms.uddeim.php:326 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4333 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4353 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4383 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:1355 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:260 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 369. Query Time: 0.11 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 80.883 MB Rows returned: 1 SELECT COUNT(id) FROM sda_menu WHERE link LIKE '%com_uddeim%' AND published=1 AND access<=2 AND language IN ('en-GB','*') LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_menu range idx_language idx_language 21 NULL 99 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/components/com_uddeim/includes.db.php:283 JROOT/components/com_uddeim/includes.db.php:248 JROOT/components/com_comprofiler/plugin/user/plug_privatemessagingsystem(uddeimpms)/pms.uddeim.php:326 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4333 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4353 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4383 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:1355 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:260 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 370. Query Time: 0.23 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 80.910 MB Rows returned: 1 SELECT COUNT(*) FROM sda_session WHERE userid = 5 AND guest = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_session ref userid userid 5 const 1 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:756 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:1429 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:261 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 371. Query Time: 0.10 ms After last query: 0.51 ms Query memory: 0.030 MB Memory before query: 80.940 MB Rows returned: 1 Duplicate queries: #119 SELECT username FROM sda_users WHERE id = 5 LIMIT 0, 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_users const PRIMARY PRIMARY 4 const 1 Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/components/com_comprofiler/router.php:30 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:3388 JROOT/components/com_comprofiler/plugin/user/plug_cbconnections/cb.connections.php:281 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 372. Query Time: 0.06 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 80.959 MB Rows returned: 1 373. SELECT * 374. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbactivity' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_plugin ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:25 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:17 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 375. Query Time: 0.13 ms After last query: 0.39 ms Query memory: 0.026 MB Memory before query: 81.000 MB Rows returned: 1 376. SELECT * 377. FROM `sda_comprofiler_tabs` WHERE `pluginid` = 500 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_comprofiler_tabs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 39 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:835 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:38 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:17 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 378. Query Time: 0.82 ms After last query: 2.21 ms Query memory: 0.026 MB Memory before query: 81.341 MB Rows returned: 12 379. SELECT a.* 380. FROM `sda_comprofiler_plugin_activity` AS a 381. LEFT JOIN `sda_comprofiler_members` AS b ON b.`memberid` = a.`user_id` 382. LEFT JOIN `sda_users` AS f ON f.`id` = a.`user_id` 383. WHERE ( ( f.`id` > 0 ) AND ( ( a.`date` >= '2014-01-07 16:02:02' ) AND ( ( a.`user_id` = 1 ) OR ( ( b.`referenceid` = 1 ) AND ( ( b.`accepted` = 1 ) AND ( b.`pending` = 0 ) ) ) ) ) ) ORDER BY a.`date` DESC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL user_id NO INDEX KEY COULD BE USED NULL NULL 112 Using where; Using filesort 1 SIMPLE b ref membrefid membrefid 4 cdmasclo.a.user_id 2 Using where 1 SIMPLE f eq_ref PRIMARY PRIMARY 4 cdmasclo.a.user_id 1 Using where; Using index Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sorting result 0.1 ms Sending data 0.4 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms freeing items 0.1 ms Waiting for query cache lock 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:1568 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:126 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 384. Query Time: 0.91 ms After last query: 3.19 ms Query memory: 0.040 MB Memory before query: 82.049 MB Rows returned: 19 SHOW FULL COLUMNS FROM `sda_kunena_messages` Explain EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `sda_kunena_messages` Profile Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.3 ms System lock 0.0 ms init 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Opening tables 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Sending data 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms removing tmp table 0.1 ms closing tables 0.0 ms freeing items 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/joomla/table/table.php:229 JROOT/libraries/joomla/table/table.php:150 JROOT/libraries/kunena/tables/kunenamessages.php:43 JROOT/libraries/joomla/table/table.php:294 JROOT/libraries/kunena/database/object.php:230 JROOT/libraries/kunena/database/object.php:78 JROOT/libraries/kunena/forum/message/message.php:569 JROOT/libraries/kunena/forum/message/helper.php:41 JROOT/libraries/kunena/forum/message/message.php:81 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:31 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:41 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:1841 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:1575 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:126 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 385. Query Time: 0.11 ms After last query: 0.27 ms Query memory: 0.033 MB Memory before query: 82.125 MB Rows returned: 0 SELECT m.*, t.message FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages_text AS t ON m.id=t.mesid WHERE m.id = 36 Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/kunena/tables/kunenamessages.php:72 JROOT/libraries/kunena/database/object.php:81 JROOT/libraries/kunena/forum/message/message.php:569 JROOT/libraries/kunena/forum/message/helper.php:41 JROOT/libraries/kunena/forum/message/message.php:81 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:31 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:41 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:1841 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:1575 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:126 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 386. Query Time: 0.09 ms After last query: 1.40 ms Query memory: 0.033 MB Memory before query: 82.173 MB Rows returned: 1 387. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 388. SUM(mm.timem.time) AS after_count 390. FROM sda_kunena_messages AS m 391. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 392. WHERE m.id IN (71) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m const PRIMARY,thread PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE mm ref thread thread 5 const 1 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/kunena/forum/message/helper.php:274 JROOT/libraries/kunena/forum/message/helper.php:230 JROOT/libraries/kunena/forum/topic/topic.php:526 JROOT/libraries/kunena/forum/topic/topic.php:495 JROOT/libraries/kunena/forum/topic/topic.php:434 JROOT/libraries/kunena/forum/message/message.php:117 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/activity.php:35 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/tab. php:18 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:166 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 393. Query Time: 0.20 ms After last query: 0.82 ms Query memory: 0.030 MB Memory before query: 82.209 MB Rows returned: 96 394. SELECT f.* FROM sda_comprofiler_fields f 395. INNER JOIN sda_comprofiler_tabs AS t ON (f.tabid = t.tabid) 396. WHERE ( f.published = 1 OR f.name = 'name' ) ORDER BY t.position, t.ordering, f.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL tabid_pub_prof_ order NO INDEX KEY COULD BE USED NULL NULL 97 Using where; Using temporary; Using filesort 1 SIMPLE t eq_ref PRIMARY PRIMARY 4 cdmasclo.f.tabid 1 Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3882 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1153 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:1051 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/tab. php:21 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:166 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 397. Query Time: 0.13 ms After last query: 3.31 ms Query memory: 0.037 MB Memory before query: 82.890 MB Rows returned: 37 398. SELECT * FROM sda_comprofiler_tabs t 399. WHERE t.enabled=1 400. AND t.useraccessgroupid IN (-2,-1,1,9,6,7,2,12,3,4,5,13,10,14,11,8) ORDER BY t.position, t.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ref enabled_position_ordering,orderreg_enabled_pos_order enabled_position_ordering 1 const 36 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:369 JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:337 JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:202 JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:287 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:541 JROOT/administrator/components/com_comprofiler/plugin.class.php:371 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1156 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/cbactivity.class.php:1051 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/tab. php:21 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:166 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 401. Query Time: 0.11 ms After last query: 2.68 ms Query memory: 0.033 MB Memory before query: 83.107 MB Rows returned: 1 402. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 403. SUM(mm.timem.time) AS after_count 405. FROM sda_kunena_messages AS m 406. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 407. WHERE m.id IN (69) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m const PRIMARY,thread PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE mm ref thread thread 5 const 2 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/kunena/forum/message/helper.php:274 JROOT/libraries/kunena/forum/message/helper.php:230 JROOT/libraries/kunena/forum/topic/topic.php:526 JROOT/libraries/kunena/forum/topic/topic.php:495 JROOT/libraries/kunena/forum/topic/topic.php:434 JROOT/libraries/kunena/forum/message/message.php:117 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/activity.php:35 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/tab. php:18 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:166 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 408. Query Time: 0.10 ms After last query: 2.50 ms Query memory: 0.033 MB Memory before query: 83.148 MB Rows returned: 1 409. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 410. SUM(mm.timem.time) AS after_count 412. FROM sda_kunena_messages AS m 413. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 414. WHERE m.id IN (68) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m const PRIMARY,thread PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE mm ref thread thread 5 const 2 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/kunena/forum/message/helper.php:274 JROOT/libraries/kunena/forum/message/helper.php:230 JROOT/libraries/kunena/forum/topic/topic.php:526 JROOT/libraries/kunena/forum/topic/topic.php:495 JROOT/libraries/kunena/forum/topic/topic.php:434 JROOT/libraries/kunena/forum/message/message.php:117 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/activity.php:35 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/tab. php:18 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:166 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 415. Query Time: 0.09 ms After last query: 6.10 ms Query memory: 0.033 MB Memory before query: 83.195 MB Rows returned: 1 416. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 417. SUM(mm.timem.time) AS after_count 419. FROM sda_kunena_messages AS m 420. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 421. WHERE m.id IN (38) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m const PRIMARY,thread PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE mm ref thread thread 5 cons 4 Using where t Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/kunena/forum/message/helper.php:274 JROOT/libraries/kunena/forum/message/helper.php:230 JROOT/libraries/kunena/forum/topic/topic.php:526 JROOT/libraries/kunena/forum/topic/topic.php:495 JROOT/libraries/kunena/forum/topic/topic.php:434 JROOT/libraries/kunena/forum/message/message.php:117 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/models/kunena.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/activity.php:35 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/templates/default/tab. php:18 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:166 JROOT/components/com_comprofiler/plugin/user/plug_cbactivity/tab.cbactivity.php:11 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 422. Query Time: 0.10 ms After last query: 4.31 ms Query memory: 0.025 MB Memory before query: 83.228 MB Rows returned: 4 423. SELECT id, rules FROM `sda_viewlevels` Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/joomla/access/access.php:422 JROOT/administrator/components/com_comprofiler/library/cb/cb.acl.php:221 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2703 JROOT/components/com_comprofiler/plugin/user/plug_cblastviewstab/cb.lastviews.php: 52 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 424. Query Time: 0.07 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 83.252 MB Rows returned: 3 425. SELECT v.viewer_id, lastview, v.viewscount, c.avatar, c.avatarapproved, c.banned, u.username, u.name 426. FROM `sda_comprofiler_views` v, `sda_comprofiler` c, `sda_users` u WHERE 427. v.profile_id = 1 428. AND c.id = v.viewer_id 429. AND u.id = c.id 430. AND c.id NOT IN (62,67,100000) 431. ORDER BY v.lastview DESC LIMIT 10 Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE v ref PRIMARY,profile_id_lastview profile_id_lastview 4 const 3 Using where 1 SIMPLE c eq_ ref PRIMARY PRIMARY 4 cdmasclo.v.viewer_id 1 1 SIMPLE u eq_ ref PRIMARY PRIMARY 4 cdmasclo.c.id 1 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/components/com_comprofiler/plugin/user/plug_cblastviewstab/cb.lastviews.php: 95 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 432. Query Time: 0.13 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 83.280 MB Rows returned: 1 433. SELECT count(viewer_id) FROM `sda_comprofiler_views` WHERE profile_id = 1 AND viewer_id = 0 Explain id select_type table type possible_keys key key_ len ref rows Extra 1 SIMPLE sda_comprofiler_views ref PRIMARY,profile_id_lastview PRIMARY 8 const,const 1 Using index Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:756 JROOT/components/com_comprofiler/plugin/user/plug_cblastviewstab/cb.lastviews.php: 150 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 434. Query Time: 0.13 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 83.321 MB Rows returned: 1 435. SELECT c.*, u.* 436. FROM sda_users AS u LEFT JOIN sda_comprofiler AS c ON c.id = u.id WHERE u.id = 10 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:783 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:767 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1057 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1014 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:950 JROOT/components/com_comprofiler/plugin/user/plug_cblastviewstab/cb.lastviews.php: 158 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 437. Query Time: 0.12 ms After last query: 0.26 ms Query memory: 0.030 MB Memory before query: 83.383 MB Rows returned: 2 438. SELECT a.id 439. FROM sda_user_usergroup_map AS map 440. LEFT JOIN sda_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 10 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE map ref PRIMARY PRIMARY 4 const 2 Using index 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 cdmasclo.map.group_id 1 Using index Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/libraries/joomla/access/access.php:336 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:816 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:804 JROOT/administrator/components/com_comprofiler/library/cb/cb.tables.php:780 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1057 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1014 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:950 JROOT/components/com_comprofiler/plugin/user/plug_cblastviewstab/cb.lastviews.php: 158 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 441. Query Time: 0.14 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 83.393 MB Rows returned: 66 442. SELECT f.* FROM sda_comprofiler_fields f 443. INNER JOIN sda_comprofiler_tabs AS t ON (f.tabid = t.tabid) 444. WHERE ( f.published = 1 OR f.name = 'name' ) AND ( f.profile != 0 OR f.name = 'username' OR f.name = 'name') AND t.enabled = 1 AND t.viewaccesslevel IN (1,2,3) AND t.useraccessgroupid IN (-2,-1,1,9,6,7,2,12,3,4,5,13,10,14,11,8) ORDER BY t.position, t.ordering, f.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL tabid_pub_prof_order NO INDEX KEY COULD BE USED NULL NULL 97 Using where; Using temporary; Using filesort 1 SIMPLE t eq_ref PRIMARY,enabled_position_ordering,orderreg_enabled_pos_order PRIMARY 4 cdmasclo.f.tabid 1 Using where Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:705 JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:876 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3882 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1153 JROOT/components/com_comprofiler/plugin/user/plug_cblastviewstab/cb.lastviews.php: 159 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 445. Query Time: 0.11 ms After last query: 2.73 ms Query memory: 0.037 MB Memory before query: 83.875 MB Rows returned: 1 Duplicate queries: #144 #145 SELECT username FROM sda_users WHERE id = 10 LIMIT 0, 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_users const PRIMARY PRIMARY 4 const 1 Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking privileges on cached 0.0 ms checking permissions 0.0 ms sending cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/components/com_comprofiler/router.php:30 JROOT/libraries/cms/router/site.php:455 JROOT/libraries/cms/router/site.php:413 JROOT/libraries/cms/router/router.php:216 JROOT/libraries/cms/router/site.php:98 JROOT/libraries/joomla/application/route.php:62 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2818 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:2913 JROOT/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php:193 JROOT/administrator/components/com_comprofiler/plugin.class.php:815 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:375 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1156 JROOT/components/com_comprofiler/plugin/user/plug_cblastviewstab/cb.lastviews.php: 159 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:4187 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3377 JROOT/administrator/components/com_comprofiler/comprofiler.class.php:3432 JROOT/administrator/components/com_comprofiler/plugin.foundation.php:1177 JROOT/components/com_comprofiler/comprofiler.html.php:433 JROOT/components/com_comprofiler/comprofiler.php:710 JROOT/components/com_comprofiler/comprofiler.php:103 JROOT/libraries/cms/component/helper.php:351 JROOT/libraries/cms/component/helper.php:331 JROOT/libraries/cms/application/site.php:178 JROOT/libraries/cms/application/site.php:208 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] ---