446. Query Time: 0.09 ms After last query: 0.50 ms Query memory: 0.037 MB Memory before query: 83.913 MB Rows returned: 1 Duplicate queries: #143 #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: 160 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] --- 447. Query Time: 0.09 ms After last query: 0.57 ms Query memory: 0.039 MB Memory before query: 83.951 MB Rows returned: 1 Duplicate queries: #143 #144 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:2814 JROOT/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php:2427 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: 161 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] --- 448. Query Time: 0.14 ms After last query: 0.34 ms Query memory: 0.027 MB Memory before query: 84.000 MB Rows returned: 1 449. SELECT c.*, u.* 450. FROM sda_users AS u LEFT JOIN sda_comprofiler AS c ON c.id = u.id WHERE u.id = 6 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] --- 451. Query Time: 0.09 ms After last query: 0.27 ms Query memory: 0.030 MB Memory before query: 84.063 MB Rows returned: 7 452. SELECT a.id 453. FROM sda_user_usergroup_map AS map 454. LEFT JOIN sda_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 6 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE map ref PRIMARY PRIMARY 4 const 7 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] --- 455. Query Time: 0.09 ms After last query: 0.42 ms Query memory: 0.037 MB Memory before query: 84.079 MB Rows returned: 1 Duplicate queries: #149 #150 SELECT username FROM sda_users WHERE id = 6 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] --- 456. Query Time: 0.10 ms After last query: 0.54 ms Query memory: 0.037 MB Memory before query: 84.116 MB Rows returned: 1 Duplicate queries: #148 #150 SELECT username FROM sda_users WHERE id = 6 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: 160 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] --- 457. Query Time: 0.14 ms After last query: 0.54 ms Query memory: 0.039 MB Memory before query: 84.154 MB Rows returned: 1 Duplicate queries: #148 #149 SELECT username FROM sda_users WHERE id = 6 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:2814 JROOT/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php:2427 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: 161 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] --- 458. Query Time: 0.13 ms After last query: 0.34 ms Query memory: 0.027 MB Memory before query: 84.202 MB Rows returned: 1 459. SELECT c.*, u.* 460. FROM sda_users AS u LEFT JOIN sda_comprofiler AS c ON c.id = u.id WHERE u.id = 7 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] --- 461. Query Time: 0.12 ms After last query: 0.24 ms Query memory: 0.030 MB Memory before query: 84.264 MB Rows returned: 7 462. SELECT a.id 463. FROM sda_user_usergroup_map AS map 464. LEFT JOIN sda_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 7 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE map ref PRIMARY PRIMARY 4 const 7 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] --- 465. Query Time: 0.10 ms After last query: 0.45 ms Query memory: 0.037 MB Memory before query: 84.280 MB Rows returned: 1 Duplicate queries: #154 #155 SELECT username FROM sda_users WHERE id = 7 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] --- 466. Query Time: 0.13 ms After last query: 0.50 ms Query memory: 0.037 MB Memory before query: 84.318 MB Rows returned: 1 Duplicate queries: #153 #155 SELECT username FROM sda_users WHERE id = 7 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: 160 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] --- 467. Query Time: 0.09 ms After last query: 0.54 ms Query memory: 0.039 MB Memory before query: 84.356 MB Rows returned: 1 Duplicate queries: #153 #154 SELECT username FROM sda_users WHERE id = 7 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:2814 JROOT/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php:2427 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: 161 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] --- 468. Query Time: 0.13 ms After last query: 0.37 ms Query memory: 0.025 MB Memory before query: 84.378 MB Rows returned: 1 469. SELECT * 470. FROM `sda_comprofiler_plugin` WHERE `element` = 'cbinvites' 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_cbinvites/cbinvites.class.php:25 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/tab.cbinvites.php:12 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] --- 471. Query Time: 0.12 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 84.410 MB Rows returned: 1 472. SELECT * 473. FROM `sda_comprofiler_tabs` WHERE `pluginid` = 506 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_cbinvites/cbinvites.class.php:38 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/tab.cbinvites.php:12 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] --- 474. Query Time: 0.11 ms After last query: 0.65 ms Query memory: 0.025 MB Memory before query: 84.496 MB Rows returned: 0 475. SELECT a.* 476. FROM `sda_comprofiler_plugin_invites` AS a 477. WHERE ( a.`user_id` = 1 ) ORDER BY a.`sent` 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 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_cbinvites/cbinvites.class.php:1460 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/tab.cbinvites.php:34 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] --- 478. Query Time: 0.10 ms After last query: 0.57 ms Query memory: 0.026 MB Memory before query: 84.526 MB Rows returned: 0 479. SELECT `id` 480. FROM `sda_menu` 481. WHERE `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbinvites%' 482. AND `published` = 1 483. 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 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_cbinvites/cbinvites.class.php:89 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.class.php:134 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/templates/default/tab.php:19 JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/tab.cbinvites.php:51 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] --- 484. Query Time: 0.10 ms After last query: 1.33 ms Query memory: 0.026 MB Memory before query: 84.671 MB Rows returned: 0 485. SELECT a.* 486. FROM `sda_groupjive_categories` AS a 487. WHERE ( a.`user_id` = 1 ) ORDER BY a.`ordering` ASC Explain i select_ tabl typ possible key key_ ref row Extra d type e e _keys len s 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 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_cbgroupjive/cbgroupjive.class.php:6675 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:66 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:390 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] --- 488. Query Time: 0.12 ms After last query: 1.12 ms Query memory: 0.026 MB Memory before query: 84.801 MB Rows returned: 0 489. SELECT a.* 490. FROM `sda_groupjive_groups` AS a 491. WHERE ( a.`user_id` = 1 ) ORDER BY a.`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 NULL NULL NULL Impossible WHERE noticed after reading const tables USED 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_cbgroupjive/cbgroupjive.class.php:6801 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:148 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:391 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] --- 492. Query Time: 0.14 ms After last query: 1.15 ms Query memory: 0.026 MB Memory before query: 84.932 MB Rows returned: 0 493. SELECT a.* 494. FROM `sda_groupjive_groups` AS a 495. LEFT JOIN `sda_groupjive_users` AS e ON e.` group` = a.`id` 496. WHERE ( ( e.`user_id` = 1 ) AND ( e.`status` NOT IN ( '-1', '0', '4' ) ) ) ORDER BY a.`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 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/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:6801 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:230 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:392 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] --- 497. Query Time: 0.13 ms After last query: 0.95 ms Query memory: 0.026 MB Memory before query: 85.011 MB Rows returned: 0 498. SELECT a.* 499. FROM `sda_groupjive_invites` AS a 500. WHERE ( a.`user_id` = 1 ) ORDER BY a.`accepted` 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 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_cbgroupjive/cbgroupjive.class.php:7012 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:275 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:393 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] --- 501. Query Time: 0.64 ms After last query: 1.07 ms Query memory: 0.026 MB Memory before query: 85.126 MB Rows returned: 0 502. SELECT a.* 503. FROM `sda_groupjive_groups` AS a 504. LEFT JOIN `sda_groupjive_invites` AS f ON f.` group` = a.`id` 505. WHERE ( ( f.`user` = 1 ) OR ( f.`email` = 'allenjj@mhcable.com' ) ) 506. AND ( f.`accepted` IN ( '0000-00-00', '0000-00-00 00:00:00', '', NULL ) ) ORDER BY a.`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 Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.3 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms storing result in query cache 0.1 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms end 0.0 ms query end 0.0 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/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/cbgroupjive.class.php:6801 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:354 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:394 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] --- 507. Query Time: 0.11 ms After last query: 0.93 ms Query memory: 0.026 MB Memory before query: 85.216 MB Rows returned: 1 508. SELECT `id` 509. FROM `sda_menu` 510. WHERE `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbgroupjive%' 511. AND `published` = 1 512. 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 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_cbgroupjive/cbgroupjive.class.php:121 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php:197 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/templates/default/tab.php:32 JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/tab.cbgroupjive.php:397 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] --- 513. Query Time: 0.11 ms After last query: 1.79 ms Query memory: 0.026 MB Memory before query: 85.258 MB Rows returned: 0 514. SELECT `id` 515. FROM `sda_menu` 516. WHERE `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbblogs%' 517. AND `published` = 1 518. 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 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_cbblogs/cbblogs.class.php:137 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.class.php:182 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/templates/default/tab.php:19 JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/tab.cbblogs.php:59 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] --- 519. Query Time: 0.12 ms After last query: 1.79 ms Query memory: 0.025 MB Memory before query: 85.358 MB Rows returned: 1 Duplicate queries: #81 #83 #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 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:193 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 54 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 520. Query Time: 0.13 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 85.383 MB Rows returned: 10 Duplicate queries: #82 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 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:201 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 54 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 521. Query Time: 0.10 ms After last query: 0.95 ms Query memory: 0.025 MB Memory before query: 85.444 MB Rows returned: 1 Duplicate queries: #81 #83 #167 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 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:193 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 64 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 522. Query Time: 0.15 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 85.469 MB Rows returned: 10 523. SELECT m.*, t.message 524. FROM sda_kunena_messages AS m 525. INNER JOIN sda_kunena_messages_text AS t ON m.id = t.mesid 526. 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, 15 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 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:201 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 64 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 527. Query Time: 0.12 ms After last query: 2.47 ms Query memory: 0.031 MB Memory before query: 85.488 MB Rows returned: 1 528. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 529. SUM(mm.timem.time) AS after_count 531. FROM sda_kunena_messages AS m 532. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 533. WHERE m.id IN (37) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m cons PRIMARY,thre PRIMAR 4 cons 1 Using temporar t ad Y t y; Using filesort 1 SIMPLE mm ref thread thread 5 const 3 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_cbforums/models/kunena20.php: 77 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 534. Query Time: 0.06 ms After last query: 0.82 ms Query memory: 0.031 MB Memory before query: 85.525 MB Rows returned: 1 535. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 536. SUM(mm.timem.time) AS after_count 538. FROM sda_kunena_messages AS m 539. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 540. WHERE m.id IN (35) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m cons PRIMARY,thre PRIMAR 4 cons 1 Using temporar t ad Y t y; 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_cbforums/models/kunena20.php: 77 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 541. Query Time: 0.12 ms After last query: 0.92 ms Query memory: 0.031 MB Memory before query: 85.565 MB Rows returned: 1 542. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 543. SUM(mm.timem.time) AS after_count 545. FROM sda_kunena_messages AS m 546. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 547. WHERE m.id IN (34) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m cons PRIMARY,thre PRIMAR 4 cons 1 Using temporar t ad Y t y; Using filesort 1 SIMPLE mm ref thread thread 5 const 4 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_cbforums/models/kunena20.php: 77 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 548. Query Time: 0.11 ms After last query: 0.65 ms Query memory: 0.031 MB Memory before query: 85.602 MB Rows returned: 1 549. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 550. SUM(mm.timem.time) AS after_count 552. FROM sda_kunena_messages AS m 553. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 554. WHERE m.id IN (33) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m cons PRIMARY,thre PRIMAR 4 cons 1 Using temporar t ad Y t y; 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_cbforums/models/kunena20.php: 77 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 555. Query Time: 0.12 ms After last query: 0.93 ms Query memory: 0.031 MB Memory before query: 85.642 MB Rows returned: 1 556. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 557. SUM(mm.timem.time) AS after_count 559. FROM sda_kunena_messages AS m 560. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 561. WHERE m.id IN (2) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m cons PRIMARY,thre PRIMAR 4 cons 1 Using temporar t ad Y t y; 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_cbforums/models/kunena20.php: 77 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 562. Query Time: 0.12 ms After last query: 0.84 ms Query memory: 0.031 MB Memory before query: 85.680 MB Rows returned: 1 563. SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, 564. SUM(mm.timem.time) AS after_count 566. FROM sda_kunena_messages AS m 567. INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 568. WHERE m.id IN (1) GROUP BY m.id, mm.hold Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m cons PRIMARY,thre PRIMAR 4 cons 1 Using temporar t ad Y t y; 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_cbforums/models/kunena20.php: 77 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:23 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 569. Query Time: 0.12 ms After last query: 2.02 ms Query memory: 0.025 MB Memory before query: 85.743 MB Rows returned: 1 Duplicate queries: #98 #99 #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 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/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 120 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:30 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 570. Query Time: 0.08 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 85.770 MB Rows returned: 1 Duplicate queries: #98 #99 #177 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 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/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 130 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:30 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 571. Query Time: 0.10 ms After last query: 1.04 ms Query memory: 0.025 MB Memory before query: 85.819 MB Rows returned: 0 Duplicate queries: #180 SELECT COUNT(*) FROM sda_kunena_categories AS c INNER JOIN sda_kunena_user_categories AS u ON u.category_id = c.id WHERE u.user_id IN (1) AND u.category_id IN (31,6,48,1,39,16,2,32,40,7,17,5,3,33,4,18,8,15,41,42,34,9,19,30,43,38,10,35,20,44,47,11,21,36,45,22,37,12,46,23,13,14,24,25,26,27,28,29,0) AND u.subscribed=1 GROUP BY c.id Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c index PRIMARY PRIMARY 4 NULL 48 Using where; Using index 1 SIMPLE u eq_ref PRIMARY,category_subscribed PRIMARY 8 const,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 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/category/helper.php:147 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 247 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:36 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 572. Query Time: 0.11 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 85.846 MB Rows returned: 0 Duplicate queries: #179 SELECT COUNT(*) FROM sda_kunena_categories AS c INNER JOIN sda_kunena_user_categories AS u ON u.category_id = c.id WHERE u.user_id IN (1) AND u.category_id IN (31,6,48,1,39,16,2,32,40,7,17,5,3,33,4,18,8,15,41,42,34,9,19,30,43,38,10,35,20,44,47,11,21,36,45,22,37,12,46,23,13,14,24,25,26,27,28,29,0) AND u.subscribed=1 GROUP BY c.id Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c index PRIMARY PRIMARY 4 NULL 48 Using where; Using index 1 SIMPLE u eq_ref PRIMARY,category_subscribed PRIMARY 8 const,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 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/category/helper.php:147 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 257 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:36 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 573. Query Time: 0.10 ms After last query: 0.73 ms Query memory: 0.025 MB Memory before query: 85.912 MB Rows returned: 1 Duplicate queries: #94 #96 #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 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/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 186 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:37 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 574. Query Time: 0.14 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 85.937 MB Rows returned: 8 Duplicate queries: #95 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 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/topic/helper.php:238 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 186 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:37 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 575. Query Time: 0.09 ms After last query: 0.60 ms Query memory: 0.025 MB Memory before query: 86.007 MB Rows returned: 1 Duplicate queries: #94 #96 #181 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 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/topic/helper.php:216 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 196 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:37 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 576. Query Time: 0.13 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 86.032 MB Rows returned: 8 577. 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 578. FROM sda_kunena_user_topics AS ut 579. 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, 15 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 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/topic/helper.php:238 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/models/kunena20.php: 196 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/templates/default/tab.php:37 JROOT/components/com_comprofiler/plugin/user/plug_cbforums/tab.cbforums.php:59 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] --- 580. Query Time: 0.16 ms After last query: 11.96 ms Query memory: 0.022 MB Memory before query: 87.509 MB Rows returned: 1 Duplicate queries: #35 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 COUL NULL NULL 1 D BE USED 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_adsmanager/models/configuration.php:26 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.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] --- 581. Query Time: 0.12 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 87.559 MB Rows returned: 2 SELECT f.title,f.fieldid,f.catsid FROM sda_adsmanager_fields AS f WHERE f.sort = 1 AND f.published = 1 ORDER BY f.ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort 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_adsmanager/models/field.php:59 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:119 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] --- 582. Query Time: 0.11 ms After last query: 0.58 ms Query memory: 0.025 MB Memory before query: 87.587 MB Rows returned: 4 583. SELECT group_id FROM sda_user_usergroup_map WHERE user_id = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_user_usergroup_ map ref PRIMARY PRIMARY 4 const 4 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/components/com_adsmanager/helpers/usergroups.php:28 JROOT/components/com_adsmanager/lib/tpermissions.php:35 JROOT/administrator/components/com_adsmanager/models/content.php:417 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:157 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] --- 584. Query Time: 0.07 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 87.614 MB Rows returned: 12 SELECT c.* FROM sda_adsmanager_categories as c WHERE 1 ORDER BY c.parent,c.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 12 Using filesort 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_adsmanager/models/category.php:77 JROOT/components/com_adsmanager/lib/tpermissions.php:40 JROOT/administrator/components/com_adsmanager/models/content.php:417 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:157 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] --- 585. Query Time: 0.08 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 87.639 MB Rows returned: 1 SELECT * FROM sda_paidsystem_config WHERE 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_paidsystem_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 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_paidsystem/api.paidsystem.php:545 JROOT/components/com_paidsystem/api.paidsystem.php:738 JROOT/administrator/components/com_adsmanager/models/content.php:439 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:157 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] --- 586. Query Time: 0.13 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 87.671 MB Rows returned: 1 SELECT adext.*, a.id FROM sda_adsmanager_ads as a LEFT JOIN sda_paidsystem_ads as adext ON a.id = adext.id INNER JOIN sda_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN sda_users as u ON a.userid = u.id LEFT JOIN sda_comprofiler as cb ON cb.user_id = a.userid INNER JOIN sda_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN sda_adsmanager_categories as p ON c.parent = p.id WHERE u.id = 1 AND c.id IN (1,2,12,3,4,5,9,6,7,8,10,11) GROUP BY a.id 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 a index PRIMARY PRIMARY 4 NULL 7 Using where 1 SIMPLE adext eq_ref PRIMARY PRIMARY 4 cdmasclo.a.id 1 1 SIMPLE adcat ref PRIMARY PRIMARY 4 cdmasclo.a.id 1 Using where; Using index 1 SIMPLE cb eq_ref user_id user_id 4 cdmasclo.a.userid 1 Using index 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 cdmasclo.adcat.catid 1 1 SIMPLE p eq_ref PRIMARY PRIMARY 4 cdmasclo.c.parent 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 checking permissions 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_adsmanager/models/content.php:443 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:157 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] --- 587. Query Time: 0.13 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 87.693 MB Rows returned: 1 SELECT adext.*, a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname FROM sda_adsmanager_ads as a LEFT JOIN sda_paidsystem_ads as adext ON a.id = adext.id INNER JOIN sda_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN sda_comprofiler as cb ON cb.user_id = a.userid LEFT JOIN sda_users as u ON a.userid = u.id INNER JOIN sda_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN sda_adsmanager_categories as p ON c.parent = p.id WHERE u.id = 1 GROUP BY a.id ORDER BY a.date_created DESC ,a.id DESC LIMIT 0, 20 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE a index PRIMARY PRIMARY 4 NULL 7 Using where 1 SIMPLE adext eq_ref PRIMARY PRIMARY 4 cdmasclo.a.id 1 1 SIMPLE adcat ref PRIMARY PRIMARY 4 cdmasclo.a.id 1 Using index 1 SIMPLE cb eq_ref user_id user_id 4 cdmasclo.a.userid 1 Using index 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 cdmasclo.adcat. catid 1 1 SIMPLE p eq_ref PRIMARY PRIMARY 4 cdmasclo.c.parent 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 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 cached result to clien 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_adsmanager/models/content.php:385 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.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] --- 588. Query Time: 0.11 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 87.727 MB Rows returned: 4 SELECT c.* FROM sda_adsmanager_columns as c ORDER BY c.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX NULL NULL 4 Using KEY COULD BE USED filesort 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_adsmanager/models/column.php:32 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:182 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] --- 589. Query Time: 0.12 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 87.754 MB Rows returned: 7 SELECT c.* FROM sda_adsmanager_fields AS c WHERE c.columnid != -1 AND c.published = 1 ORDER by c.columnorder,c.fieldid Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort 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_adsmanager/models/field.php:157 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:183 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] --- 590. Query Time: 0.13 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 87.819 MB Rows returned: 13 SELECT * FROM sda_adsmanager_fields as f WHERE f.published = 1 ORDER by f.ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort 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_adsmanager/models/field.php:88 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:194 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] --- 591. Query Time: 0.14 ms After last query: 0.41 ms Query memory: 0.022 MB Memory before query: 87.914 MB Rows returned: 8 SELECT * FROM sda_adsmanager_field_values ORDER by ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_field_values ALL NULL NO INDEX KEY COULD BE USED NULL NULL 8 Using filesort 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_adsmanager/models/field.php:233 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:204 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] --- 592. Query Time: 0.11 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 87.950 MB Rows returned: 13 SELECT fieldid,cbfieldvalues FROM sda_adsmanager_fields as f WHERE published = 1 ORDER by f.ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort 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_adsmanager/models/field.php:252 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:204 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] --- 593. Query Time: 0.09 ms After last query: 3.47 ms Query memory: 0.026 MB Memory before query: 88.606 MB Rows returned: 1 SELECT id,language FROM sda_menu WHERE link LIKE '%option=com_adsmanager&view=myads%' AND published ='1' AND type ='component' 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 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_adsmanager/lib/route.php:210 JROOT/components/com_adsmanager/lib/route.php:94 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:29 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 594. Query Time: 0.11 ms After last query: 1.16 ms Query memory: 0.027 MB Memory before query: 88.739 MB Rows returned: 1 SELECT id,language FROM sda_menu WHERE link LIKE '%option=com_adsmanager&view=edit%' AND published ='1' AND type ='component' 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 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_adsmanager/lib/route.php:210 JROOT/components/com_adsmanager/lib/route.php:94 JROOT/components/com_adsmanager/helpers/general.php:39 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:76 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 595. Query Time: 0.11 ms After last query: 0.78 ms Query memory: 0.027 MB Memory before query: 88.767 MB Rows returned: 1 SELECT id,language FROM sda_menu WHERE link LIKE '%option=com_adsmanager&view=rules%' AND published ='1' AND type ='component' Explain id select_typ table type possible_key key key_le ref row Extra e s n s 1 SIMPLE sda_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 191 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_adsmanager/lib/route.php:210 JROOT/components/com_adsmanager/lib/route.php:94 JROOT/components/com_adsmanager/helpers/general.php:46 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:76 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 596. Query Time: 0.11 ms After last query: 0.38 ms Query memory: 0.027 MB Memory before query: 88.794 MB Rows returned: 0 SELECT id,language FROM sda_menu WHERE link LIKE '%option=com_adsmanager&view=list%' AND published ='1' AND type ='component' 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 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_adsmanager/lib/route.php:210 JROOT/components/com_adsmanager/lib/route.php:94 JROOT/components/com_adsmanager/helpers/general.php:47 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:76 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 597. Query Time: 0.09 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 88.821 MB Rows returned: 1 SELECT id FROM sda_menu WHERE link = 'index.php?option=com_adsmanager&view=front' AND published ='1' AND type ='component' 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 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_adsmanager/lib/route.php:321 JROOT/components/com_adsmanager/lib/route.php:117 JROOT/components/com_adsmanager/helpers/general.php:47 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:76 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 598. Query Time: 0.12 ms After last query: 0.47 ms Query memory: 0.026 MB Memory before query: 88.849 MB Rows returned: 0 SELECT id,language FROM sda_menu WHERE link LIKE '%option=com_adsmanager&view=details%' AND published ='1' AND type ='component' 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 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_adsmanager/lib/route.php:257 JROOT/components/com_adsmanager/lib/route.php:92 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:100 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 599. Query Time: 0.06 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 88.875 MB Rows returned: 0 SELECT id,language FROM sda_menu WHERE link LIKE '%option=com_adsmanager&view=list%' AND link LIKE '%catid=2%' AND published ='1' AND type ='component' 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 NULL NULL 191 Using where USED 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_adsmanager/lib/route.php:281 JROOT/components/com_adsmanager/lib/route.php:92 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:100 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 600. Query Time: 0.12 ms After last query: 0.22 ms Query memory: 0.032 MB Memory before query: 88.905 MB Rows returned: 1 Duplicate queries: #206 #208 SELECT name FROM sda_adsmanager_categories WHERE id = 2 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_categories 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_adsmanager/router.php:20 JROOT/components/com_adsmanager/router.php:76 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/components/com_adsmanager/lib/route.php:176 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:100 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 601. Query Time: 0.11 ms After last query: 0.25 ms Query memory: 0.033 MB Memory before query: 88.937 MB Rows returned: 1 Duplicate queries: #207 #209 SELECT ad_headline FROM sda_adsmanager_ads WHERE id = 7 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_ads 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_adsmanager/router.php:31 JROOT/components/com_adsmanager/router.php:77 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/components/com_adsmanager/lib/route.php:176 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:100 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 602. Query Time: 0.10 ms After last query: 0.47 ms Query memory: 0.032 MB Memory before query: 88.969 MB Rows returned: 1 Duplicate queries: #204 #208 SELECT name FROM sda_adsmanager_categories WHERE id = 2 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_categories 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_adsmanager/router.php:20 JROOT/components/com_adsmanager/router.php:174 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/components/com_adsmanager/lib/route.php:176 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:170 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 603. Query Time: 0.11 ms After last query: 0.20 ms Query memory: 0.033 MB Memory before query: 89.002 MB Rows returned: 1 Duplicate queries: #205 #209 SELECT ad_headline FROM sda_adsmanager_ads WHERE id = 7 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_ads 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_adsmanager/router.php:31 JROOT/components/com_adsmanager/router.php:175 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/components/com_adsmanager/lib/route.php:176 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:170 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 604. Query Time: 0.11 ms After last query: 0.41 ms Query memory: 0.032 MB Memory before query: 89.034 MB Rows returned: 1 Duplicate queries: #204 #206 SELECT name FROM sda_adsmanager_categories WHERE id = 2 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_categories 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_adsmanager/router.php:20 JROOT/components/com_adsmanager/router.php:193 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/components/com_adsmanager/lib/route.php:176 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:173 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 605. Query Time: 0.08 ms After last query: 0.21 ms Query memory: 0.033 MB Memory before query: 89.067 MB Rows returned: 1 Duplicate queries: #205 #207 SELECT ad_headline FROM sda_adsmanager_ads WHERE id = 7 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sda_adsmanager_ads 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_adsmanager/router.php:31 JROOT/components/com_adsmanager/router.php:194 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/components/com_adsmanager/lib/route.php:176 JROOT/components/com_adsmanager/views/myads/tmpl/default.php:173 JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661 JROOT/components/com_comprofiler/plugin/user/plug_adsmanager- tab/adsmanager.plugin.php:213 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] --- 606. Query Time: 0.80 ms After last query: 2.94 ms Query memory: 0.026 MB Memory before query: 89.171 MB Rows returned: 0 607. SELECT b.id FROM sda_cbsubs_payment_baskets b 608. WHERE b.payment_status = 'NotInitiated' 609. AND b.payment_method IS NULL 610. AND b.user_id = 1 AND b.time_initiated < DATE_SUB( NOW(), INTERVAL 3 HOUR) LIMIT 0, 100 Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE b ref user_id,payment_status,status_time_completed_date,status_time_completed_dayofweek,status_time_completed_yearweek,status_time_completed_yearmonth,status_time_completed_hou user_i 4 con 1 Using whe r d st re Profile Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.1 ms checking permissions 0.0 ms Opening tables 0.5 ms System lock 0.0 ms init 0.0 ms optimizing 0.0 ms statistics 0.1 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 logging slow query 0.0 ms cleaning up 0.0 ms Call Stack JROOT/administrator/components/com_comprofiler/library/cb/cb.database.php:769 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/order/cbpaidOrdersMgr.php:59 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:134 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 611. Query Time: 0.12 ms After last query: 1.90 ms Query memory: 0.031 MB Memory before query: 89.620 MB Rows returned: 1 612. SELECT s.* FROM sda_cbsubs_subscriptions s 613. LEFT JOIN sda_cbsubs_plans AS a ON a.`id` = s.`plan_id` 614. LEFT JOIN sda_cbsubs_plans AS b ON b.`id` = a.`parent` 615. WHERE s.user_id = 1 616. GROUP BY s.`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 s ref user_status_ plan user_status_ plan 4 const 1 Using where; Using temporary; Using filesort 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 cdmasclo.s.plan_id 1 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 cdmasclo.a.parent 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 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: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/cbpaidSubscriptionsMgr.php:75 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:265 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:137 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 617. Query Time: 0.26 ms After last query: 0.33 ms Query memory: 0.030 MB Memory before query: 89.662 MB Rows returned: 11 618. SELECT a.* FROM `sda_cbsubs_plans` AS a 619. LEFT JOIN `sda_cbsubs_plans` AS b ON b.`id` = a.`parent` 620. WHERE a.published = 1 AND a.access IN (-2,-1,1,9,6,7,2,12,3,4,5,13,10,14,11,8) AND a.viewaccesslevel IN (1,2,3) 621. 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 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.1 ms logging slow query 0.0 ms cleaning up 0.0 ms 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/libraries/cbpaidSubscriptionsMgr.php:79 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:265 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:137 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 622. Query Time: 0.22 ms After last query: 2.08 ms Query memory: 0.032 MB Memory before query: 90.163 MB Rows returned: 11 623. SELECT a.* FROM `sda_cbsubs_plans` AS a 624. LEFT JOIN `sda_cbsubs_plans` AS b ON b.`id` = a.`parent` 625. WHERE a.published = 1 AND a.allow_newsubscriptions = 1 AND a.allow_upgrade_to_this = 1 AND a.allow_frontend = 1 AND a.access IN (-2,-1,1,9,6,7,2,12,3,4,5,13,10,14,11,8) AND a.viewaccesslevel IN (1,2,3) 626. 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,fe_published_allownew_allowreg_parent_order,upgrade_published_allownew_parent_ordering,allownew_published_upgrade_fe_parent_order published_allownew_allowreg_parent_ordering 2 const,const 10 Using where; Using temporary; Using files ort 1 SIMPLE b eq_ ref PRIMARY PRIMARY 4 cdmasclo.a. parent 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.1 ms logging slow query 0.0 ms cleaning up 0.0 ms 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/models/product/cbpaidProduct.php:383 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/something/cbpaidSomething.php:417 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:93 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:265 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:137 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 627. Query Time: 0.12 ms After last query: 1.82 ms Query memory: 0.032 MB Memory before query: 90.581 MB Rows returned: 8 628. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name 629. FROM sda_comprofiler_plugin 630. WHERE published = 1 AND access IN (0,1,2) AND type = 'user/plug_cbpaidsubscriptions/plugin' 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 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/administrator/components/com_comprofiler/plugin.class.php:123 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/something/cbpaidSomething.php:344 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/something/cbpaidSomething.php:428 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:93 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:265 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:137 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 631. Query Time: 0.19 ms After last query: 11.48 ms Query memory: 0.042 MB Memory before query: 93.890 MB Rows returned: 0 632. SELECT * 633. FROM `sda_cbsubs_promotions` AS m 634. WHERE m.`published` = 1 ORDER BY m.`priority`, m.`ordering` 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 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: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/models/table/cbpaidTable.php:321 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php:177 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php:818 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php:1934 JROOT/administrator/components/com_comprofiler/plugin.class.php:583 JROOT/administrator/components/com_comprofiler/plugin.class.php:541 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/misc/cbpaidItem.php:167 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/something/cbpaidSomething.php:352 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/something/cbpaidSomething.php:428 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:93 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:265 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:137 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 635. Query Time: 0.17 ms After last query: 0.59 ms Query memory: 0.031 MB Memory before query: 93.917 MB Rows returned: 1 636. SELECT a.* FROM `sda_cbsubs_plans` AS a WHERE a.`id` = 2 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a 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.1 ms logging slow query 0.0 ms cleaning up 0.0 ms 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/controllers/cbpaidControllerUI.php:1045 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:273 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:137 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 637. Query Time: 0.58 ms After last query: 78.23 ms Query memory: 0.027 MB Memory before query: 96.174 MB Rows returned: 1 638. SELECT COUNT(*) 639. FROM sda_cbsubs_payment_baskets b 640. WHERE b.user_id = 1 641. AND b.time_initiated > '2009-02-07 11:02:02' 642. AND payment_status IN ( 'Completed', 'Pending' ) ORDER BY b.time_initiated DESC Explain id select_ type table type possible_keys key key_ len ref rows Extra 1 SIMPLE b ref user_id,payment_status,status_time_completed_date,status_time_completed_dayofweek,status_time_completed_yearweek,status_time_completed_yearmonth,status_time_completed_hour user_id 4 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.1 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.1 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/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/order/cbpaidOrdersMgr.php:175 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:57 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBTab.php:143 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:213 JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:232 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] --- 643. Query Time: 0.58 ms After last query: 53.19 ms Query memory: 0.031 MB Memory before query: 98.378 MB Rows returned: 1 644. SELECT extension_id AS id, element AS "option", params, enabled 645. FROM sda_extensions WHERE `type` = 'component' AND `element` = 'com_invoicing' 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 Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.1 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.1 ms preparing 0.0 ms executing 0.0 ms Sending data 0.1 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/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_invoicing/helpers/cparams.php:18 JROOT/components/com_invoicing/dispatcher.php:28 JROOT/libraries/fof/dispatcher/dispatcher.php:284 JROOT/components/com_comprofiler/plugin/user/plug_invoicinginvoices- tab/invoices.plugin.php:29 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] --- 646. Query Time: 1.38 ms After last query: 66.59 ms Query memory: 0.003 MB Memory before query: 100.123 MB 647. UPDATE `sda_session` 648. SET `data` = '__default|a:7:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1391788488;s:18:\"session.timer.last\";i:1391788913;s:17:\"session.timer.now\";i:1391788922;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":2:{s:10:\" user0_read\";a:49:{i:0;i:0;i:31;s:2:\"31\";i:6;s:1:\"6\";i:48;s:2:\"48\ ";i:1;s:1:\"1\";i:39;s:2:\"39\";i:16;s:2:\"16\";i:2;s:1:\"2\";i:32;s:2: \"32\";i:40;s:2:\"40\";i:7;s:1:\"7\";i:17;s:2:\"17\";i:5;s:1:\"5\";i:3; s:1:\"3\";i:33;s:2:\"33\";i:4;s:1:\"4\";i:18;s:2:\"18\";i:8;s:1:\"8\";i:15;s:2:\"15\";i:41;s:2:\"41\";i:42;s:2:\"42\";i:34;s:2:\"34\";i:9;s:1: \"9\";i:19;s:2:\"19\";i:30;s:2:\"30\";i:43;s:2:\"43\";i:38;s:2:\"38\";i:10;s:2:\"10\";i:35;s:2:\"35\";i:20;s:2:\"20\";i:44;s:2:\"44\";i:47;s:2:\"47\";i:11;s:2:\"11\";i:21;s:2:\"21\";i:36;s:2:\"36\";i:45;s:2:\"45\" ;i:22;s:2:\"22\";i:37;s:2:\"37\";i:12;s:2:\"12\";i:46;s:2:\"46\";i:23;s:2:\"23\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:24;s:2:\"24\";i:25;s:2:\"25\";i:26;s:2:\"26\";i:27;s:2:\"27\";i:28;s:2:\"28\";i:29;s:2:\"29\";}s:10:\"user1_read\";a:49:{i:31;s:2:\"31\";i:6;s:1:\"6\";i:48;s:2:\"48\";i: 1;s:1:\"1\";i:39;s:2:\"39\";i:16;s:2:\"16\";i:2;s:1:\"2\";i:32;s:2:\"32\";i:40;s:2:\"40\";i:7;s:1:\"7\";i:17;s:2:\"17\";i:5;s:1:\"5\";i:3;s:1: \"3\";i:33;s:2:\"33\";i:4;s:1:\"4\";i:18;s:2:\"18\";i:8;s:1:\"8\";i:15; s:2:\"15\";i:41;s:2:\"41\";i:42;s:2:\"42\";i:34;s:2:\"34\";i:9;s:1:\"9\ ";i:19;s:2:\"19\";i:30;s:2:\"30\";i:43;s:2:\"43\";i:38;s:2:\"38\";i:10; s:2:\"10\";i:35;s:2:\"35\";i:20;s:2:\"20\";i:44;s:2:\"44\";i:47;s:2:\"47\";i:11;s:2:\"11\";i:21;s:2:\"21\";i:36;s:2:\"36\";i:45;s:2:\"45\";i:22;s:2:\"22\";i:37;s:2:\"37\";i:12;s:2:\"12\";i:46;s:2:\"46\";i:23;s:2:\ "23\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:24;s:2:\"24\";i:25;s:2:\"25\";i:26;s:2:\"26\";i:27;s:2:\"27\";i:28;s:2:\"28\";i:29;s:2:\"29\";i:0;i:0; }}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:1:\"1\";s:4:\"name\";s:10:\"John Allen\";s:8:\"username\";s:8:\"cdmasclo\";s:5:\"email\";s:19:\"allenjj@ mhcable.com\";s:8:\"password\";s:34:\"$P$DFCTn8aUFM6ahii3uOxcjcV/8zDjqH.\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-06-08 23:50:35\";s:13:\"lastvisitDate\";s:19:\"2014-02-07 15:52:52\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:109:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\" ,\"helpsite\":\"\",\"timezone\":\"America\\/New_York\"}\";s:6:\"groups\ ";a:4:{i:3;s:1:\"3\";i:4;s:1:\"4\";i:5;s:1:\"5\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9: \"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\ ";s:16:\"America/New_York\";}}s:14:\"\\0\\0\\0_authGroups\";a:6:{i:0;i: 1;i:1;i:2;i:2;i:3;i:6;i:4;i:11;i:5;i:13;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\ ";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\ "aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}}referrerid|s:13:\"52E5C7CFC7655\";' 649. , `time` = '1391788922' WHERE `session_id` = 'b5o83j6bk8nr5v2n2hr92lmmq2' Explain EXPLAIN not possible on query: UPDATE `sda_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1391788488;s:18: \"session.timer.last\";i:1391788913;s:17:\"session.timer.now\";i:1391788922;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":2:{s:10:\"user0_read\";a:49:{i:0;i:0;i:31;s:2:\"31\ ";i:6;s:1:\"6\";i:48;s:2:\"48\";i:1;s:1:\"1\";i:39;s:2:\"39\";i:16;s:2:\"16\";i:2;s:1:\"2\";i:32;s: 2:\"32\";i:40;s:2:\"40\";i:7;s:1:\"7\";i:17;s:2:\"17\";i:5;s:1:\"5\";i:3;s:1:\"3\";i:33;s:2:\"33\"; i:4;s:1:\"4\";i:18;s:2:\"18\";i:8;s:1:\"8\";i:15;s:2:\"15\";i:41;s:2:\"41\";i:42;s:2:\"42\";i:34;s:2:\"34\";i:9;s:1:\"9\";i:19;s:2:\"19\";i:30;s:2:\"30\";i:43;s:2:\"43\";i:38;s:2:\"38\";i:10;s:2:\ "10\";i:35;s:2:\"35\";i:20;s:2:\"20\";i:44;s:2:\"44\";i:47;s:2:\"47\";i:11;s:2:\"11\";i:21;s:2:\" 21\";i:36;s:2:\"36\";i:45;s:2:\"45\";i:22;s:2:\"22\";i:37;s:2:\"37\";i:12;s:2:\"12\";i:46;s:2:\" 46\";i:23;s:2:\"23\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:24;s:2:\"24\";i:25;s:2:\"25\";i:26;s:2:\" 26\";i:27;s:2:\"27\";i:28;s:2:\"28\";i:29;s:2:\"29\";}s:10:\"user1_read\";a:49:{i:31;s:2:\"31\ ";i:6;s:1:\"6\";i:48;s:2:\"48\";i:1;s:1:\"1\";i:39;s:2:\"39\";i:16;s:2:\"16\";i:2;s:1:\"2\";i:32;s: 2:\"32\";i:40;s:2:\"40\";i:7;s:1:\"7\";i:17;s:2:\"17\";i:5;s:1:\"5\";i:3;s:1:\"3\";i:33;s:2:\"33\"; i:4;s:1:\"4\";i:18;s:2:\"18\";i:8;s:1:\"8\";i:15;s:2:\"15\";i:41;s:2:\"41\";i:42;s:2:\"42\";i:34;s:2:\"34\";i:9;s:1:\"9\";i:19;s:2:\"19\";i:30;s:2:\"30\";i:43;s:2:\"43\";i:38;s:2:\"38\";i:10;s:2:\ "10\";i:35;s:2:\"35\";i:20;s:2:\"20\";i:44;s:2:\"44\";i:47;s:2:\"47\";i:11;s:2:\"11\";i:21;s:2:\" 21\";i:36;s:2:\"36\";i:45;s:2:\"45\";i:22;s:2:\"22\";i:37;s:2:\"37\";i:12;s:2:\"12\";i:46;s:2:\" 46\";i:23;s:2:\"23\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:24;s:2:\"24\";i:25;s:2:\"25\";i:26;s:2:\" 26\";i:27;s:2:\"27\";i:28;s:2:\"28\";i:29;s:2:\"29\";i:0;i:0;}}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:1:\"1\";s:4:\"name\";s:10:\"John Allen\";s:8:\"username\";s:8:\"cdmasclo\";s:5:\"email\";s:19:\"allenjj@mhcable.com\";s:8:\"password\";s:34:\"$P$DFCTn8aUFM6ahii3uOxcjcV/8zDjqH.\";s:14:\"password_clear\ ";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-06-08 23:50:35\";s:13:\"lastvisitDate\";s:19:\"2014-02-07 15:52:52\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:109:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"America\ \/New_York\"}\";s:6:\"groups\";a:4:{i:3;s:1:\"3\";i:4;s:1:\"4\";i:5;s:1:\"5\";i:8;s:1:\"8\";}s: 5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\ ";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:16:\"America/New_York\";}}s:14:\"\\0\\0\\0_authGroups\";a:6:{i:0;i:1;i:1;i:2;i:2;i:3;i:6;i:4;i:11;i:5;i:13;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s: 15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{ }s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}}referrerid|s:13:\"52E5C7CFC7655\";' , `time` = '1391788922' WHERE `session_id` = 'b5o83j6bk8nr5v2n2hr92lmmq2' Profile Status Duration starting 0.2 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms init 0.1 ms Updating 0.2 ms end 0.0 ms Waiting for query cache lock 0.0 ms end 0.0 ms query end 0.6 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/session/storage/database.php:85 [Add xdebug.file_link_format directive to your php.ini file to have links for files] --- 99 Query Types Logged, Sorted by Occurrences. SELECT Tables: 1. 11 × SELECT username FROM sda_users 2. 10 × SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.timem.time) AS after_count FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages AS mm ON m.thread=mm.thread 3. 10 × SELECT alias FROM sda_content 4. 9 × SELECT extension_id AS id, element AS "option", params, enabled FROM sda_extensions 5. 8 × SELECT COUNT(*) FROM sda_kunena_user_topics AS ut INNER JOIN sda_kunena_topics AS tt ON tt.id=ut.topic_id 6. 8 × SELECT * FROM sda_kunena_topics 7. 8 × SELECT * FROM `sda_comprofiler_plugin` 8. 7 × 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 9. 6 × SELECT * FROM `sda_comprofiler_tabs` 10. 6 × SELECT id,language FROM sda_menu 11. 5 × SELECT id FROM sda_assets 12. 5 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, 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 FROM sda_categories as c 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) 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 13. 4 × 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 14. 4 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM sda_comprofiler_plugin 15. 4 × SELECT m.*, t.message FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages_text AS t ON m.id = t.mesid 16. 4 × SELECT `id` FROM `sda_menu` 17. 4 × SELECT COUNT(*) FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages_text AS t ON m.id = t.mesid 18. 4 × SELECT c.*, u.* FROM sda_users AS u LEFT JOIN sda_comprofiler AS c ON c.id = u.id 19. 4 × SELECT a.id FROM sda_user_usergroup_map AS map LEFT JOIN sda_usergroups AS a ON a.id = map.group_id 20. 3 × SELECT b.rules FROM sda_assets AS a LEFT JOIN sda_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 21. 3 × SELECT name FROM sda_adsmanager_categories 22. 3 × SELECT ad_headline FROM sda_adsmanager_ads 23. 3 × SELECT a.* FROM `sda_cbsubs_plans` AS a LEFT JOIN `sda_cbsubs_plans` AS b ON b.`id` = a.`parent` 24. 2 × SELECT * FROM sda_comprofiler_tabs t 25. 2 × SELECT DISTINCT(user_id) FROM sda_usergroups as ug1 INNER JOIN sda_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN sda_user_usergroup_map AS m ON ug2.id=m.group_id 26. 2 × SELECT f.* FROM sda_comprofiler_fields f INNER JOIN sda_comprofiler_tabs AS t ON (f.tabid = t.tabid) 27. 2 × SELECT `enabled` FROM `sda_extensions` 28. 2 × SELECT `value` FROM `sda_admintools_storage` 29. 2 × SELECT COUNT(*) FROM sda_kunena_categories AS c INNER JOIN sda_kunena_user_categories AS u ON u.category_id = c.id 30. 2 × SELECT id FROM sda_menu 31. 2 × SELECT * FROM `sda_usergroups` 32. 2 × SELECT * FROM sda_adsmanager_confi 33. 2 × SELECT a.* FROM `sda_cbsubs_plans` AS a 34. 1 × SELECT a.* FROM `sda_groupjive_groups` AS a 35. 1 × SELECT a.* FROM `sda_groupjive_groups` AS a LEFT JOIN `sda_groupjive_users` AS e ON e.` group` = a.`id` 36. 1 × SELECT a.* FROM `sda_groupjive_groups` AS a LEFT JOIN `sda_groupjive_invites` AS f ON f.` group` = a.`id` 37. 1 × SELECT a.* FROM `sda_groupjive_categories` AS a 38. 1 × SELECT a.* FROM `sda_groupjive_invites` AS a 39. 1 × SELECT a.* FROM `sda_comprofiler_plugin_invites` AS a 40. 1 × SELECT id, rules FROM `sda_viewlevels 41. 1 × SELECT COUNT(*) FROM sda_cbsubs_payment_baskets b 42. 1 × SELECT * FROM `sda_cbsubs_promotions` AS m 43. 1 × SELECT v.viewer_id, lastview, v.viewscount, c.avatar, c.avatarapproved, c.banned, u.username, u.name FROM `sda_comprofiler_views` v, `sda_comprofiler` c, `sda_users` u 44. 1 × SELECT count(viewer_id) FROM `sda_comprofiler_views` 45. 1 × SELECT f.title,f.fieldid,f.catsid FROM sda_adsmanager_fields AS f 46. 1 × SELECT group_id FROM sda_user_usergroup_map 47. 1 × SELECT b.id FROM sda_cbsubs_payment_baskets b 48. 1 × SELECT * FROM sda_adsmanager_fields as f 49. 1 × SELECT * FROM sda_adsmanager_field_values 50. 1 × SELECT fieldid,cbfieldvalues FROM sda_adsmanager_fields as f 51. 1 × SELECT folder AS type, element AS name, params FROM sda_extensions 52. 1 × SELECT c.* FROM sda_adsmanager_fields AS c 53. 1 × SELECT m.*, t.message FROM sda_kunena_messages AS m INNER JOIN sda_kunena_messages_text AS t ON m.id=t.mesid 54. 1 × SELECT * FROM sda_paidsystem_config 55. 1 × SELECT c.* FROM sda_adsmanager_categories as c 56. 1 × SELECT adext.*, a.id FROM sda_adsmanager_ads as a LEFT JOIN sda_paidsystem_ads as adext ON a.id = adext.id INNER JOIN sda_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN sda_users as u ON a.userid = u.id LEFT JOIN sda_comprofiler as cb ON cb.user_id = a.userid INNER JOIN sda_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN sda_adsmanager_categories as p ON c.parent = p.id 57. 1 × SELECT adext.*, a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname FROM sda_adsmanager_ads as a LEFT JOIN sda_paidsystem_ads as adext ON a.id = adext.id INNER JOIN sda_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN sda_comprofiler as cb ON cb.user_id = a.userid LEFT JOIN sda_users as u ON a.userid = u.id INNER JOIN sda_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN sda_adsmanager_categories as p ON c.parent = p.id 58. 1 × SELECT c.* FROM sda_adsmanager_columns as c 59. 1 × SELECT s.* FROM sda_cbsubs_subscriptions s LEFT JOIN sda_cbsubs_plans AS a ON a.`id` = s.`plan_id` LEFT JOIN sda_cbsubs_plans AS b ON b.`id` = a.`parent` 60. 1 × SELECT COUNT(*) FROM sda_comprofiler_members AS m LEFT JOIN sda_comprofiler AS c ON m.memberid=c.id LEFT JOIN sda_users AS u ON m.memberid=u.id 61. 1 × SELECT a.* FROM `sda_comprofiler_plugin_antispam_log` AS a 62. 1 × SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level FROM `sda_usergroups` AS a LEFT JOIN `sda_usergroups` AS b ON a.`lft` > b.`lft` AND a.`rgt` < b.`rgt` GROUP BY a.`id` 63. 1 × SELECT a.* FROM `sda_comprofiler_plugin_antispam_whitelist` AS a 64. 1 × SELECT * FROM sda_languages 65. 1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* FROM sda_users AS u LEFT JOIN sda_kunena_users AS ku ON u.id = ku.userid 66. 1 × SELECT id, home, template, s.params FROM sda_template_styles as s LEFT JOIN sda_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id 67. 1 × SELECT b.id FROM sda_user_usergroup_map AS map LEFT JOIN sda_usergroups AS a ON a.id = map.group_id LEFT JOIN sda_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 68. 1 × SELECT rules FROM sda_assets 69. 1 × SELECT * FROM sda_kunena_configuration 70. 1 × SELECT * FROM `sda_cbsubs_config` 71. 1 × SELECT * FROM `sda_comprofiler_plugin_autoactions` 72. 1 × SELECT * FROM `sda_groupjive_plugin_auto` 73. 1 × SELECT COUNT(*) FROM sda_rantispam_banip 74. 1 × SELECT parent.id, parent.lft, parent.rgt FROM sda_usergroups AS parent 75. 1 × SELECT * FROM sda_kunena_categories 76. 1 × SELECT * FROM sda_kunena_rank 77. 1 × SELECT s.* FROM sda_cbsubs_subscriptions s 78. 1 × SELECT `query` FROM `sda_admintools_wafexceptions` 79. 1 × SELECT m.*,u.name,u.email,u.username,c.avatar,c.avatarapproved, u.id FROM sda_comprofiler_members AS m LEFT JOIN sda_comprofiler AS c ON m.memberid=c.id LEFT JOIN sda_users AS u ON m.memberid=u.id 80. 1 × SELECT * FROM sda_comprofiler_plugin p 81. 1 × SELECT COUNT(*) FROM sda_session 82. 1 × SELECT COUNT(id) FROM sda_menu 83. 1 × SELECT * FROM `sda_admintools_ipautoban` 84. 1 × 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 FROM sda_content AS a LEFT JOIN sda_content_rating AS r ON r.content_id=a.id LEFT JOIN sda_categories AS cc ON cc.id = a.catid 85. 1 × SELECT `data` FROM `sda_session` 86. 1 × SELECT user_id, category_id, role FROM sda_kunena_user_categories 87. 1 × 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 FROM sda_menu AS m LEFT JOIN sda_extensions AS e ON m.component_id = e.extension_id 88. 1 × SELECT * FROM `sda_admintools_storage` 89. 1 × SELECT `word` FROM `sda_admintools_badwords` GROUP BY `word 90. 1 × SELECT `source`,`keepurlparams` FROM `sda_admintools_redirects` 91. 1 × SELECT a.* FROM `sda_comprofiler_plugin_activity` AS a LEFT JOIN `sda_comprofiler_members` AS b ON b.`memberid` = a.`user_id` LEFT JOIN `sda_users` AS f ON f.`id` = a.`user_id` OTHER Tables: 1. 1 × SHOW FULL COLUMNS FROM `sda_kunena_topics 2. 1 × SHOW FULL COLUMNS FROM `sda_kunena_messages 3. 1 × UPDATE `sda_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1391788488;s:18:\"session.timer.last\";i:1391788913;s:17:\"session.timer.now\";i:1391788922;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":2:{s:10:\" user0_read\";a:49:{i:0;i:0;i:31;s:2:\"31\";i:6;s:1:\"6\";i:48;s:2:\"48\ ";i:1;s:1:\"1\";i:39;s:2:\"39\";i:16;s:2:\"16\";i:2;s:1:\"2\";i:32;s:2: \"32\";i:40;s:2:\"40\";i:7;s:1:\"7\";i:17;s:2:\"17\";i:5;s:1:\"5\";i:3; s:1:\"3\";i:33;s:2:\"33\";i:4;s:1:\"4\";i:18;s:2:\"18\";i:8;s:1:\"8\";i:15;s:2:\"15\";i:41;s:2:\"41\";i:42;s:2:\"42\";i:34;s:2:\"34\";i:9;s:1: \"9\";i:19;s:2:\"19\";i:30;s:2:\"30\";i:43;s:2:\"43\";i:38;s:2:\"38\";i:10;s:2:\"10\";i:35;s:2:\"35\";i:20;s:2:\"20\";i:44;s:2:\"44\";i:47;s:2:\"47\";i:11;s:2:\"11\";i:21;s:2:\"21\";i:36;s:2:\"36\";i:45;s:2:\"45\" ;i:22;s:2:\"22\";i:37;s:2:\"37\";i:12;s:2:\"12\";i:46;s:2:\"46\";i:23;s:2:\"23\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:24;s:2:\"24\";i:25;s:2:\"25\";i:26;s:2:\"26\";i:27;s:2:\"27\";i:28;s:2:\"28\";i:29;s:2:\"29\";}s:10:\"user1_read\";a:49:{i:31;s:2:\"31\";i:6;s:1:\"6\";i:48;s:2:\"48\";i: 1;s:1:\"1\";i:39;s:2:\"39\";i:16;s:2:\"16\";i:2;s:1:\"2\";i:32;s:2:\"32\";i:40;s:2:\"40\";i:7;s:1:\"7\";i:17;s:2:\"17\";i:5;s:1:\"5\";i:3;s:1: \"3\";i:33;s:2:\"33\";i:4;s:1:\"4\";i:18;s:2:\"18\";i:8;s:1:\"8\";i:15; s:2:\"15\";i:41;s:2:\"41\";i:42;s:2:\"42\";i:34;s:2:\"34\";i:9;s:1:\"9\ ";i:19;s:2:\"19\";i:30;s:2:\"30\";i:43;s:2:\"43\";i:38;s:2:\"38\";i:10; s:2:\"10\";i:35;s:2:\"35\";i:20;s:2:\"20\";i:44;s:2:\"44\";i:47;s:2:\"47\";i:11;s:2:\"11\";i:21;s:2:\"21\";i:36;s:2:\"36\";i:45;s:2:\"45\";i:22;s:2:\"22\";i:37;s:2:\"37\";i:12;s:2:\"12\";i:46;s:2:\"46\";i:23;s:2:\ "23\";i:13;s:2:\"13\";i:14;s:2:\"14\";i:24;s:2:\"24\";i:25;s:2:\"25\";i:26;s:2:\"26\";i:27;s:2:\"27\";i:28;s:2:\"28\";i:29;s:2:\"29\";i:0;i:0; }}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:1:\"1\";s:4:\"name\";s:10:\"John Allen\";s:8:\"username\";s:8:\"cdmasclo\";s:5:\"email\";s:19:\"allenjj@ mhcable.com\";s:8:\"password\";s:34:\"$P$DFCTn8aUFM6ahii3uOxcjcV/8zDjqH.\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-06-08 23:50:35\";s:13:\"lastvisitDate\";s:19:\"2014-02-07 15:52:52\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:109:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\" ,\"helpsite\":\"\",\"timezone\":\"America\\/New_York\"}\";s:6:\"groups\ ";a:4:{i:3;s:1:\"3\";i:4;s:1:\"4\";i:5;s:1:\"5\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9: \"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\ ";s:16:\"America/New_York\";}}s:14:\"\\0\\0\\0_authGroups\";a:6:{i:0;i: 1;i:1;i:2;i:2;i:3;i:6;i:4;i:11;i:5;i:13;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\ ";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\ "aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}}referrerid|s:13:\"52E5C7CFC7655\";' , `time` = '1391788922' 4. 1 × SHOW FULL COLUMNS FROM `sda_kunena_categories 5. 1 × SHOW FULL COLUMNS FROM `sda_kunena_users 6. 1 × SHOW FULL COLUMNS FROM `sda_users 7. 1 × SHOW FULL COLUMNS FROM `sda_assets 8. 1 × UPDATE `sda_extensions` SET `params` = '{\"mediaversion\":\"63eeb38db773b8bb88d8bbebb3cda34c\"}'