Error after Joomla Update 3.2.3 / 3.3.0

**Joomla! Debug Console** **Session** **Profile Information** **Memory Usage** **Database Queries** **16 Queries Logged** 42.3 ms 1. **Query Time: 0.50 ms** **Query memory: 0.007 MB Memory before query: 1.400 MB** **Rows returned: 1** SELECT `data` FROM `syi7r_session` WHERE `session_id` = '8mir0njs32lk4smhtj8g156ks1' **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE syi7r_session const PRIMARY PRIMARY 602 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/libraries/joomla/session/storage/database.php:46 JROOT/libraries/joomla/session/session.php:658 JROOT/libraries/joomla/session/session.php:596 JROOT/libraries/cms/application/cms.php:672 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/administrator.php:45 JROOT/libraries/cms/application/cms.php:332 JROOT/libraries/joomla/factory.php:124 JROOT/administrator/index.php:39 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 2. **Query Time: 7.13 ms** **After last query: 1.23 ms** **Query memory: 0.004 MB Memory before query: 1.464 MB** DELETE FROM `syi7r_session` WHERE `time` < '1399644531' **Explain** **EXPLAIN not possible on query: DELETE FROM `syi7r_session` WHERE `time` < '1399644531'** **Profile** Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms init 0.1 ms updating 0.1 ms end 0.0 ms Waiting for query cache lock 0.0 ms end 0.1 ms query end 6.3 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/cms/application/cms.php:689 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/administrator.php:45 JROOT/libraries/cms/application/cms.php:332 JROOT/libraries/joomla/factory.php:124 JROOT/administrator/index.php:39 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 3. **Query Time: 3.86 ms** **After last query: 18.92 ms** **Query memory: 0.007 MB Memory before query: 1.846 MB** **Rows returned: 73** SELECT folder AS type, element AS name, params FROM syi7r_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3) ORDER BY ordering **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE syi7r_extensions ALL extension **NO INDEX KEY COULD BE USED** NULL NULL 190 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.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.0 ms preparing 0.0 ms executing 0.0 ms Sorting result 0.3 ms Sending data 0.1 ms Waiting for query cache lock 0.0 ms Sending data 0.5 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms Waiting for query cache lock 0.0 ms freeing items 0.1 ms Waiting for query cache lock 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms **Call Stack** JROOT/libraries/cms/plugin/helper.php:312 JROOT/libraries/cms/plugin/helper.php:88 JROOT/libraries/cms/plugin/helper.php:130 JROOT/libraries/cms/application/cms.php:573 JROOT/libraries/cms/application/administrator.php:285 JROOT/libraries/cms/application/administrator.php:116 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 4.**Query Time: 1.02 ms** **After last query: 44.78 ms** **Query memory: 0.012 MB Memory before query: 3.073 MB** **Rows returned: 1** SELECT extension_id AS id, element AS "option", params, enabled FROM syi7r_extensions WHERE `type` = 'library' AND `element` = 'joomla' **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE syi7r_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where **Profile** Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms optimizing 0.0 ms statistics 0.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/libraries/joomla/cache/controller/callback.php:158 JROOT/libraries/cms/library/helper.php:156 JROOT/libraries/cms/library/helper.php:47 JROOT/libraries/cms/library/helper.php:90 JROOT/libraries/cms/version/version.php:179 JROOT/libraries/joomla/factory.php:734 JROOT/libraries/joomla/factory.php:215 JROOT/plugins/system/sef/sef.php:30 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/administrator.php:448 JROOT/libraries/cms/application/administrator.php:137 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 5. **Query Time: 6.04 ms** **After last query: 0.35 ms** **Query memory: 0.010 MB Memory before query: 3.070 MB** UPDATE `syi7r_extensions` SET `params` = '{\"mediaversion\":\"81dad8ef00070c1ce3af1766a062e698\"}' WHERE `type` = 'library' AND `element` = 'joomla' **Explain** **EXPLAIN not possible on query: UPDATE `syi7r_extensions` SET `params` = '{\"mediaversion\":\"81dad8ef00070c1ce3af1766a062e698\"}' WHERE `type` = 'library' AND `element` = 'joomla'** **Profile** Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms init 0.1 ms Updating 0.1 ms end 0.0 ms Waiting for query cache lock 0.0 ms end 2.6 ms query end 2.9 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/cms/library/helper.php:119 JROOT/libraries/cms/version/version.php:230 JROOT/libraries/cms/version/version.php:189 JROOT/libraries/joomla/factory.php:734 JROOT/libraries/joomla/factory.php:215 JROOT/plugins/system/sef/sef.php:30 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/libraries/cms/application/administrator.php:448 JROOT/libraries/cms/application/administrator.php:137 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 6. **Query Time: 1.12 ms** **After last query: 2.65 ms** **Query memory: 0.004 MB Memory before query: 3.201 MB** **Rows returned: 1** SELECT template, s.params FROM syi7r_template_styles as s LEFT JOIN syi7r_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = 1 AND home = '1' ORDER BY home **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_home idx_home 21 const 2 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 madman_db2.s.template,const 1 **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.0 ms System lock 0.0 ms Waiting for query cache lock 0.1 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.2 ms logging slow query 0.0 ms cleaning up 0.0 ms **Call Stack** JROOT/libraries/cms/application/administrator.php:203 JROOT/libraries/cms/application/administrator.php:82 JROOT/libraries/cms/application/administrator.php:143 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 7. **Query Time: 0.95 ms** **After last query: 4.62 ms** **Query memory: 0.008 MB Memory before query: 3.284 MB** **Rows returned: 1** SELECT extension_id AS id, element AS "option", params, enabled FROM syi7r_extensions WHERE `type` = 'component' AND `element` = 'com_hikashop' **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE syi7r_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.0 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms optimizing 0.0 ms statistics 0.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:396 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:73 JROOT/libraries/cms/component/helper.php:320 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:143 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 8. **Query Time: 4.46 ms** **After last query: 21.96 ms** **Query memory: 0.008 MB Memory before query: 4.114 MB** **Rows returned: 263** SELECT * FROM syi7r_hikashop_config **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE syi7r_hikashop_config ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 263 **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.6 ms logging slow query 0.0 ms cleaning up 0.0 ms **Call Stack** JROOT/administrator/components/com_hikashop/classes/config.php:16 JROOT/administrator/components/com_hikashop/helpers/helper.php:837 JROOT/administrator/components/com_hikashop/helpers/helper.php:2578 JROOT/administrator/components/com_hikashop/hikashop.php:14 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:143 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 9. **Query Time: 0.82 ms** **After last query: 84.55 ms** **Query memory: 0.012 MB Memory before query: 6.877 MB** **Rows returned: 3** SELECT * FROM syi7r_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE syi7r_hikashop_widget ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 11 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_hikashop/classes/widget.php:35 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:73 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1323 JROOT/administrator/components/com_hikashop/helpers/helper.php:1072 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1311 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:143 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 10. **Query Time: 1.69 ms** **After last query: 0.41 ms** **Query memory: 0.012 MB Memory before query: 6.919 MB** **Rows returned: 0** SELECT b.*,a.* FROM syi7r_hikashop_order AS a LEFT JOIN syi7r_hikashop_user AS b ON a.order_user_id=b.user_id WHERE a.order_type='sale' AND a.order_created > 1398895200 AND a.order_created < 1399645731 ORDER BY a.order_created DESC LIMIT 7 **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 2 Using where; **Using filesort** 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 madman_db2.a.order_user_id 1 **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.5 ms System lock 0.1 ms Waiting for query cache lock 0.0 ms init 0.1 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sorting result 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.1 ms Waiting for query cache lock 0.0 ms freeing items 0.0 ms storing result in query cache 0.0 ms logging slow query 0.0 ms cleaning up 0.0 ms **Call Stack** JROOT/administrator/components/com_hikashop/classes/widget.php:1195 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1323 JROOT/administrator/components/com_hikashop/helpers/helper.php:1072 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1311 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:143 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 11. **Query Time: 0.32 ms** **After last query: 0.16 ms** **Query memory: 0.016 MB Memory before query: 6.934 MB** **Rows returned: 0** SELECT category_id FROM syi7r_hikashop_category WHERE category_type='root' LIMIT 1 **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE syi7r_hikashop_category ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 45 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_hikashop/classes/category.php:374 JROOT/administrator/components/com_hikashop/classes/category.php:380 JROOT/administrator/components/com_hikashop/classes/category.php:421 JROOT/administrator/components/com_hikashop/classes/category.php:386 JROOT/administrator/components/com_hikashop/classes/category.php:511 JROOT/administrator/components/com_hikashop/classes/widget.php:1460 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1323 JROOT/administrator/components/com_hikashop/helpers/helper.php:1072 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1311 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:143 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 12. **Query Time: 0.34 ms** **After last query: 0.15 ms** **Query memory: 0.015 MB Memory before query: 6.950 MB** SELECT category_id FROM syi7r_hikashop_category WHERE category_parent_id= AND category_type='status' LIMIT 1 **Explain** Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category_type='status' LIMIT 1' at line 1 SQL=EXPLAIN SELECT category_id FROM syi7r_hikashop_category WHERE category_parent_id= AND category_type='status' LIMIT 1 **Profile** Status Duration starting 0.0 ms Waiting for query cache lock 0.0 ms checking query cache for query 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_hikashop/classes/category.php:382 JROOT/administrator/components/com_hikashop/classes/category.php:421 JROOT/administrator/components/com_hikashop/classes/category.php:386 JROOT/administrator/components/com_hikashop/classes/category.php:511 JROOT/administrator/components/com_hikashop/classes/widget.php:1460 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1323 JROOT/administrator/components/com_hikashop/helpers/helper.php:1072 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1311 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:143 JROOT/libraries/cms/application/cms.php:255 JROOT/administrator/index.php:42 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 13. **Query Time: 1.64 ms** **After last query: 3.46 ms** **Query memory: 0.006 MB Memory before query: 7.054 MB** **Rows returned: 10** SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM syi7r_modules AS m LEFT JOIN syi7r_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN syi7r_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-05-09 14:28:51') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-05-09 14:28:51') AND m.access IN (1,1,2,3) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 35 Using where; **Using filesort** 1 SIMPLE mm ref PRIMARY PRIMARY 4 madman_db2.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 madman_db2.m.module,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 checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.1 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.1 ms executing 0.0 ms Sorting result 0.2 ms Sending data 0.3 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.1 ms logging slow query 0.0 ms cleaning up 0.0 ms **Call Stack** JROOT/libraries/cms/module/helper.php:376 JROOT/libraries/cms/module/helper.php:84 JROOT/administrator/templates/isis/error.php:34 JROOT/libraries/joomla/document/error/error.php:135 JROOT/libraries/joomla/document/error/error.php:107 JROOT/libraries/legacy/error/error.php:791 JROOT/plugins/system/redirect/redirect.php:134 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 14. **Query Time: 0.55 ms** **After last query: 16.27 ms** **Query memory: 0.009 MB Memory before query: 7.316 MB** **Rows returned: 5** SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native FROM syi7r_menu_types AS a LEFT JOIN syi7r_menu AS b ON b.menutype = a.menutype AND b.home != 0 LEFT JOIN syi7r_languages AS l ON l.lang_code = language WHERE (b.client_id = 0 OR b.client_id IS NULL) GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 5 Using temporary; **Using filesort** 1 SIMPLE b ref idx_menutype idx_menutype 74 madman_db2.a.menutype 3 Using where 1 SIMPLE l eq_ref idx_langcode idx_langcode 21 madman_db2.b.language 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/modules/mod_menu/helper.php:47 JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:139 JROOT/administrator/modules/mod_menu/tmpl/default.php:14 JROOT/administrator/modules/mod_menu/mod_menu.php:30 JROOT/libraries/cms/module/helper.php:190 JROOT/administrator/templates/isis/error.php:170 JROOT/libraries/joomla/document/error/error.php:135 JROOT/libraries/joomla/document/error/error.php:107 JROOT/libraries/legacy/error/error.php:791 JROOT/plugins/system/redirect/redirect.php:134 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 15. **Query Time: 1.52 ms** **After last query: 1.84 ms** **Query memory: 0.009 MB Memory before query: 7.354 MB** **Rows returned: 33** SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM syi7r_menu AS m LEFT JOIN syi7r_extensions AS e ON m.component_id = e.extension_id WHERE m.client_id = 1 AND e.enabled = 1 AND m.id > 1 ORDER BY m.lft **Explain** id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid idx_client_id_parent_id_alias_language 1 const 33 Using where; **Using filesort** 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 madman_db2.m.component_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.1 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms Waiting for query cache lock 0.0 ms init 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms executing 0.0 ms Sorting result 0.2 ms Sending data 0.3 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/modules/mod_menu/helper.php:85 JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:241 JROOT/administrator/modules/mod_menu/tmpl/default.php:14 JROOT/administrator/modules/mod_menu/mod_menu.php:30 JROOT/libraries/cms/module/helper.php:190 JROOT/administrator/templates/isis/error.php:170 JROOT/libraries/joomla/document/error/error.php:135 JROOT/libraries/joomla/document/error/error.php:107 JROOT/libraries/legacy/error/error.php:791 JROOT/plugins/system/redirect/redirect.php:134 [**Add xdebug.file_link_format directive to your php.ini file to have links for files**] 16. **Query Time: 10.31 ms** **After last query: 50.02 ms** **Query memory: 0.002 MB Memory before query: 7.491 MB** UPDATE `syi7r_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:11;s:19:\"session.timer.start\";i:1399645351;s:18:\"session.timer.last\";i:1399645722;s:17:\"session.timer.now\";i:1399645731;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"863\";s:4:\"name\";s:5:\"Brian\";s:8:\"username\";s:7:\"Madness\";s:5:\"email\";s:18:\"brian@madman.co.za\";s:8:\"password\";s:34:\"$P$Due7Ce.k9g071gzUUFp415T1CXSsil0\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-04-03 12:26:19\";s:13:\"lastvisitDate\";s:19:\"2014-05-09 04:28:33\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:247:\"{\"admin_style\":\"\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jckeditor\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Africa\\/Johannesburg\",\"jckuicolor\":\"#E6E6E6\"}\";s:6:\"groups\";a:1:{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\":7:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:9:\"jckeditor\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:19:\"Africa/Johannesburg\";s:10:\"jckuicolor\";s:7:\"#E6E6E6\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;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:\"\";}s:13:\"session.token\";s:32:\"12490d9f77632bc4b172681cef0d89a7\";}' , `time` = '1399645731' WHERE `session_id` = '8mir0njs32lk4smhtj8g156ks1' **Explain** **EXPLAIN not possible on query: UPDATE `syi7r_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:11;s:19:\"session.timer.start\";i:1399645351;s:18:\"session.timer.last\";i:1399645722;s:17:\"session.timer.now\";i:1399645731;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"863\";s:4:\"name\";s:5:\"Brian\";s:8:\"username\";s:7:\"Madness\";s:5:\"email\";s:18:\"brian@madman.co.za\";s:8:\"password\";s:34:\"$P$Due7Ce.k9g071gzUUFp415T1CXSsil0\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-04-03 12:26:19\";s:13:\"lastvisitDate\";s:19:\"2014-05-09 04:28:33\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:247:\"{\"admin_style\":\"\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jckeditor\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Africa\\/Johannesburg\",\"jckuicolor\":\"#E6E6E6\"}\";s:6:\"groups\";a:1:{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\":7:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:9:\"jckeditor\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:19:\"Africa/Johannesburg\";s:10:\"jckuicolor\";s:7:\"#E6E6E6\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;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:\"\";}s:13:\"session.token\";s:32:\"12490d9f77632bc4b172681cef0d89a7\";}' , `time` = '1399645731' WHERE `session_id` = '8mir0njs32lk4smhtj8g156ks1'** **Profile** Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms System lock 0.0 ms init 0.0 ms Updating 0.1 ms end 0.0 ms Waiting for query cache lock 0.0 ms end 0.0 ms query end 9.5 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**] **14 Query Types Logged, Sorted by Occurrences.** **SELECT Tables:** **2 × SELECT category_id FROM syi7r_hikashop_category** **2 × SELECT extension_id AS id, element AS "option", params, enabled FROM syi7r_extensions** **1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM syi7r_menu AS m LEFT JOIN syi7r_extensions AS e ON m.component_id = e.extension_id** **1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM syi7r_modules AS m LEFT JOIN syi7r_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN syi7r_extensions AS e ON e.element = m.module AND e.client_id = m.client_id** **1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native FROM syi7r_menu_types AS a LEFT JOIN syi7r_menu AS b ON b.menutype = a.menutype AND b.home != 0 LEFT JOIN syi7r_languages AS l ON l.lang_code = language** **1 × SELECT b.*,a.* FROM syi7r_hikashop_order AS a LEFT JOIN syi7r_hikashop_user AS b ON a.order_user_id=b.user_id** **1 × SELECT * FROM syi7r_hikashop_widget** **1 × SELECT folder AS type, element AS name, params FROM syi7r_extensions** **1 × SELECT template, s.params FROM syi7r_template_styles as s LEFT JOIN syi7r_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id** **1 × SELECT * FROM syi7r_hikashop_confi** **1 × SELECT `data` FROM `syi7r_session`** **OTHER Tables:** **1 × UPDATE `syi7r_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:11;s:19:\"session.timer.start\";i:1399645351;s:18:\"session.timer.last\";i:1399645722;s:17:\"session.timer.now\";i:1399645731;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"863\";s:4:\"name\";s:5:\"Brian\";s:8:\"username\";s:7:\"Madness\";s:5:\"email\";s:18:\"brian@madman.co.za\";s:8:\"password\";s:34:\"$P$Due7Ce.k9g071gzUUFp415T1CXSsil0\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-04-03 12:26:19\";s:13:\"lastvisitDate\";s:19:\"2014-05-09 04:28:33\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:247:\"{\"admin_style\":\"\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jckeditor\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Africa\\/Johannesburg\",\"jckuicolor\":\"#E6E6E6\"}\";s:6:\"groups\";a:1:{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\":7:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:9:\"jckeditor\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:19:\"Africa/Johannesburg\";s:10:\"jckuicolor\";s:7:\"#E6E6E6\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;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:\"\";}s:13:\"session.token\";s:32:\"12490d9f77632bc4b172681cef0d89a7\";}' , `time` = '1399645731'** **1 × UPDATE `syi7r_extensions` SET `params` = '{\"mediaversion\":\"81dad8ef00070c1ce3af1766a062e698\"}'** **1 × DELETE FROM `syi7r_session`**

$query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.$this->getRoot().' AND category_type='.$this->database->Quote($element).' LIMIT 1';

$query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.$this->database->Quote($element).' LIMIT 1';