Add/remove item in cart module goes to blank page

46 Queries Logged 10.5 ms 13 duplicate found! 2 duplicates: #6 #31 3 duplicates: #7 #32 #34 2 duplicates: #12 #27 3 duplicates: #14 #16 #21 3 duplicates: #22 #23 #25 Query Time: 0.22 ms SELECT `data` FROM `l84jw_session` WHERE `session_id` = 'd2bd1f1fcaf8cb459bb226b779a50179' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_session const PRIMARY PRIMARY 602 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/joomla/session/storage/database.php:46 JROOT/libraries/joomla/session/session.php:658 JROOT/libraries/joomla/session/session.php:596 JROOT/libraries/cms/application/cms.php:672 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/site.php:63 JROOT/libraries/cms/application/cms.php:332 JROOT/libraries/joomla/factory.php:124 JROOT/index.php:37 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.13 ms After last query: 0.89 ms DELETE FROM `l84jw_session` WHERE `time` < '1421501275' Explain EXPLAIN not possible on query: DELETE FROM `l84jw_session` WHERE `time` < '1421501275' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/application/cms.php:689 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/site.php:63 JROOT/libraries/cms/application/cms.php:332 JROOT/libraries/joomla/factory.php:124 JROOT/index.php:37 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 1.21 ms After last query: 25.70 ms 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 l84jw_menu AS m LEFT JOIN l84jw_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 67 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 priderwr_theright_pr1d3kc0r.m.component_id 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/menu/site.php:47 JROOT/libraries/cms/menu/menu.php:64 JROOT/libraries/cms/menu/menu.php:118 JROOT/libraries/cms/application/cms.php:357 JROOT/libraries/cms/application/site.php:250 JROOT/libraries/cms/router/site.php:210 JROOT/libraries/cms/router/router.php:391 JROOT/libraries/cms/router/router.php:184 JROOT/libraries/cms/router/site.php:82 JROOT/libraries/cms/application/cms.php:1029 JROOT/libraries/cms/application/site.php:720 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.17 ms After last query: 14.63 ms SELECT * FROM l84jw_hikashop_config Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_hikashop_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 270 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/config.php:16 JROOT/administrator/components/com_hikashop/helpers/helper.php:973 JROOT/administrator/components/com_hikashop/helpers/helper.php:3106 JROOT/components/com_hikashop/router.php:137 JROOT/libraries/cms/router/site.php:384 JROOT/libraries/cms/router/router.php:391 JROOT/libraries/cms/router/router.php:184 JROOT/libraries/cms/router/site.php:82 JROOT/libraries/cms/application/cms.php:1029 JROOT/libraries/cms/application/site.php:720 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 1.19 ms After last query: 1.35 ms UPDATE `l84jw_extensions` SET `params` = '{\"mediaversion\":\"9a577598c0276d4e104fc06fcbc07e14\"}' WHERE `type` = 'library' AND `element` = 'joomla' Explain EXPLAIN not possible on query: UPDATE `l84jw_extensions` SET `params` = '{\"mediaversion\":\"9a577598c0276d4e104fc06fcbc07e14\"}' WHERE `type` = 'library' AND `element` = 'joomla' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/library/helper.php:119 JROOT/libraries/cms/version/version.php:230 JROOT/libraries/cms/version/version.php:189 JROOT/libraries/joomla/factory.php:734 JROOT/libraries/joomla/factory.php:215 JROOT/administrator/components/com_hikashop/helpers/helper.php:3112 JROOT/components/com_hikashop/router.php:137 JROOT/libraries/cms/router/site.php:384 JROOT/libraries/cms/router/router.php:391 JROOT/libraries/cms/router/router.php:184 JROOT/libraries/cms/router/site.php:82 JROOT/libraries/cms/application/cms.php:1029 JROOT/libraries/cms/application/site.php:720 JROOT/libraries/cms/application/site.php:202 JROOT/libraries/cms/application/cms.php:255 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.09 ms After last query: 14.66 ms Duplicate queries: #31 SELECT a.* FROM l84jw_hikashop_cart AS a WHERE (a.cart_id = 13) AND a.cart_type = 'cart' ORDER BY a.cart_modified DESC LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/cart.php:73 JROOT/administrator/components/com_hikashop/classes/cart.php:20 JROOT/components/com_hikashop/controllers/product.php:303 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1479 JROOT/components/com_hikashop/hikashop.php:77 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 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] Query Time: 0.09 ms After last query: 1.85 ms Duplicate queries: #32 #34 SELECT a.*,b.*,c.* FROM l84jw_hikashop_cart AS a LEFT JOIN l84jw_hikashop_cart_product AS b ON a.cart_id = b.cart_id LEFT JOIN l84jw_hikashop_product AS c ON b.product_id=c.product_id WHERE b.cart_id = 13 AND b.product_id > 0 ORDER BY b.cart_product_modified ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Using filesort 1 SIMPLE b ref cart_id cart_id 4 const 1 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 priderwr_theright_pr1d3kc0r.b.product_id 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/cart.php:102 JROOT/administrator/components/com_hikashop/classes/cart.php:301 JROOT/components/com_hikashop/controllers/product.php:353 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1479 JROOT/components/com_hikashop/hikashop.php:77 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 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] Query Time: 1.13 ms After last query: 0.33 ms UPDATE `l84jw_hikashop_cart` SET `cart_type`='cart',`session_id`='d2bd1f1fcaf8cb459bb226b779a50179',`cart_modified`='1421508475' WHERE `cart_id`='13' Explain EXPLAIN not possible on query: UPDATE `l84jw_hikashop_cart` SET `cart_type`='cart',`session_id`='d2bd1f1fcaf8cb459bb226b779a50179',`cart_modified`='1421508475' WHERE `cart_id`='13' Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/helpers/helper.php:1555 JROOT/administrator/components/com_hikashop/classes/cart.php:206 JROOT/administrator/components/com_hikashop/classes/cart.php:243 JROOT/administrator/components/com_hikashop/classes/cart.php:308 JROOT/components/com_hikashop/controllers/product.php:353 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1479 JROOT/components/com_hikashop/hikashop.php:77 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 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] Query Time: 0.60 ms After last query: 18.17 ms UPDATE l84jw_hikashop_cart_product SET cart_product_quantity=4 WHERE cart_product_id=34 Explain EXPLAIN not possible on query: UPDATE l84jw_hikashop_cart_product SET cart_product_quantity=4 WHERE cart_product_id=34 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/cart.php:511 JROOT/administrator/components/com_hikashop/classes/cart.php:341 JROOT/components/com_hikashop/controllers/product.php:353 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1479 JROOT/components/com_hikashop/hikashop.php:77 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 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] Query Time: 0.23 ms After last query: 1.46 ms SELECT params FROM l84jw_extensions AS e WHERE e.element='com_widgetkit' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 302 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_widgetkit/helpers/system.php:254 JROOT/administrator/components/com_widgetkit/helpers/system.php:54 JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 JROOT/administrator/components/com_widgetkit/widgetkit.php:17 JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 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/site.php:183 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] Query Time: 1.63 ms After last query: 16.39 ms SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM l84jw_modules AS m LEFT JOIN l84jw_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN l84jw_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 <= '2015-01-17 15:27:55') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-01-17 15:27:55') AND m.access IN (1,1,2) AND m.client_id = 0 AND (mm.menuid = 185 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 50 Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 priderwr_theright_pr1d3kc0r.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 priderwr_theright_pr1d3kc0r.m.module,const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/libraries/cms/module/helper.php:364 JROOT/libraries/cms/module/helper.php:84 JROOT/libraries/joomla/document/html/html.php:502 JROOT/templates/priderock-2014/index.php:40 JROOT/libraries/joomla/document/html/html.php:570 JROOT/libraries/joomla/document/html/html.php:628 JROOT/libraries/joomla/document/html/html.php:452 JROOT/libraries/cms/application/cms.php:985 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.10 ms After last query: 18.15 ms Duplicate queries: #27 SELECT * FROM l84jw_rsform_config Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 17 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/config.php:51 JROOT/administrator/components/com_rsform/helpers/config.php:18 JROOT/administrator/components/com_rsform/helpers/config.php:98 JROOT/administrator/components/com_rsform/helpers/rsform.php:261 JROOT/administrator/components/com_rsform/helpers/legacy.php:36 JROOT/administrator/components/com_rsform/helpers/rsform.php:113 JROOT/administrator/components/com_rsform/helpers/rsform.php:35 JROOT/modules/mod_rsform/mod_rsform.php:16 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 1.92 ms SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou FROM l84jw_rsform_forms WHERE FormId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:176 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.09 ms Duplicate queries: #16 #21 SELECT `Lang` FROM l84jw_rsform_forms WHERE FormId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:2861 JROOT/administrator/components/com_rsform/helpers/rsform.php:185 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 0.11 ms SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` FROM l84jw_rsform_forms WHERE FormId='1' AND `Published`='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1324 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.13 ms Duplicate queries: #14 #21 SELECT `Lang` FROM l84jw_rsform_forms WHERE FormId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:2861 JROOT/administrator/components/com_rsform/helpers/rsform.php:1327 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.18 ms SELECT ComponentId FROM l84jw_rsform_components WHERE ComponentTypeId='6' AND FormId='1' AND Published='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_components ref ComponentTypeId,FormId ComponentTypeId 4 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1234 JROOT/administrator/components/com_rsform/helpers/rsform.php:1347 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 0.08 ms SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c. Order FROM l84jw_rsform_properties p LEFT JOIN l84jw_rsform_components c ON (c.ComponentId=p.ComponentId) LEFT JOIN l84jw_rsform_component_types ct ON (ct.ComponentTypeId=c.ComponentTypeId) WHERE c.FormId='1' AND p.PropertyName='NAME' AND c.Published='1' ORDER BY c. Order Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref ComponentId,FormId FormId 4 const 2 Using where; Using filesort 1 SIMPLE ct eq_ref PRIMARY PRIMARY 4 priderwr_theright_pr1d3kc0r.c.ComponentTypeId 1 1 SIMPLE p ref ComponentId ComponentId 4 priderwr_theright_pr1d3kc0r.c.ComponentId 12 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1386 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 0.09 ms SELECT `PropertyName`, `PropertyValue`, `ComponentId` FROM l84jw_rsform_properties WHERE `ComponentId` IN (1,3,8) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_properties ALL ComponentId NO INDEX KEY COULD BE USED NULL NULL 35 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:441 JROOT/administrator/components/com_rsform/helpers/rsform.php:1411 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.16 ms SELECT FormId FROM l84jw_rsform_components WHERE ComponentId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_components const ComponentId ComponentId 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:451 JROOT/administrator/components/com_rsform/helpers/rsform.php:1411 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.09 ms Duplicate queries: #14 #16 SELECT `Lang` FROM l84jw_rsform_forms WHERE FormId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:2861 JROOT/administrator/components/com_rsform/helpers/rsform.php:455 JROOT/administrator/components/com_rsform/helpers/rsform.php:1411 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.18 ms Duplicate queries: #23 #25 SELECT FormLayoutName FROM l84jw_rsform_forms WHERE FormId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/rsfppayment/rsfppayment.php:318 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/administrator/components/com_rsform/helpers/rsform.php:2703 JROOT/administrator/components/com_rsform/helpers/rsform.php:1443 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.14 ms Duplicate queries: #22 #25 SELECT FormLayoutName FROM l84jw_rsform_forms WHERE FormId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/rsfppayment/rsfppayment.php:318 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/administrator/components/com_rsform/helpers/rsform.php:2703 JROOT/administrator/components/com_rsform/helpers/rsform.php:1443 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.13 ms SELECT ComponentId FROM l84jw_rsform_components WHERE ComponentTypeId='41' AND FormId='1' AND Published='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_components ref ComponentTypeId,FormId ComponentTypeId 4 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1234 JROOT/administrator/components/com_rsform/helpers/rsform.php:2540 JROOT/administrator/components/com_rsform/helpers/rsform.php:1443 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.10 ms Duplicate queries: #22 #23 SELECT FormLayoutName FROM l84jw_rsform_forms WHERE FormId='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_forms system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/plugins/system/rsfppayment/rsfppayment.php:318 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/administrator/components/com_rsform/helpers/rsform.php:2703 JROOT/administrator/components/com_rsform/helpers/rsform.php:1443 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 0.23 ms SELECT c.*,p.PropertyValue AS ComponentName FROM `l84jw_rsform_conditions` c LEFT JOIN l84jw_rsform_properties p ON (c.component_id = p.ComponentId) LEFT JOIN l84jw_rsform_components comp ON (comp.ComponentId=p.ComponentId) WHERE c.`form_id` = 1 AND c.lang_code='en-GB' AND comp.Published = 1 AND p.PropertyName='NAME' ORDER BY c.`id` ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1284 JROOT/administrator/components/com_rsform/helpers/rsform.php:1557 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.12 ms Duplicate queries: #12 SELECT * FROM l84jw_rsform_config Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 17 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/config.php:51 JROOT/administrator/components/com_rsform/helpers/config.php:38 JROOT/administrator/components/com_rsform/helpers/rsform.php:264 JROOT/plugins/system/rsfppayment/rsfppayment.php:547 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/administrator/components/com_rsform/helpers/rsform.php:1608 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.13 ms SELECT ComponentId FROM l84jw_rsform_components WHERE ComponentTypeId='22' AND FormId='1' AND Published='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_components ref ComponentTypeId,FormId ComponentTypeId 4 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1234 JROOT/plugins/system/rsfppayment/rsfppayment.php:553 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/administrator/components/com_rsform/helpers/rsform.php:1608 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.08 ms SELECT ComponentId FROM l84jw_rsform_components WHERE ComponentTypeId='23' AND FormId='1' AND Published='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_components ref ComponentTypeId,FormId ComponentTypeId 4 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1234 JROOT/plugins/system/rsfppayment/rsfppayment.php:554 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/administrator/components/com_rsform/helpers/rsform.php:1608 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.05 ms After last query: 0.09 ms SELECT ComponentId FROM l84jw_rsform_components WHERE ComponentTypeId='21' AND FormId='1' AND Published='1' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_rsform_components ref ComponentTypeId,FormId ComponentTypeId 4 const 1 Using where Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_rsform/helpers/rsform.php:1234 JROOT/plugins/system/rsfppayment/rsfppayment.php:617 JROOT/libraries/joomla/event/event.php:71 JROOT/libraries/joomla/event/dispatcher.php:162 JROOT/libraries/joomla/application/base.php:106 JROOT/administrator/components/com_rsform/helpers/rsform.php:1608 JROOT/administrator/components/com_rsform/helpers/rsform.php:238 JROOT/modules/mod_rsform/tmpl/default.php:14 JROOT/modules/mod_rsform/mod_rsform.php:26 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.30 ms After last query: 10.81 ms Duplicate queries: #6 SELECT a.* FROM l84jw_hikashop_cart AS a WHERE (a.cart_id = 13) AND a.cart_type = 'cart' ORDER BY a.cart_modified DESC LIMIT 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/cart.php:73 JROOT/administrator/components/com_hikashop/classes/cart.php:20 JROOT/administrator/components/com_hikashop/classes/cart.php:97 JROOT/components/com_hikashop/views/product/view.html.php:1908 JROOT/components/com_hikashop/views/product/view.html.php:37 JROOT/administrator/components/com_hikashop/helpers/helper.php:738 JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:44 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.32 ms After last query: 0.13 ms Duplicate queries: #7 #34 SELECT a.*,b.*,c.* FROM l84jw_hikashop_cart AS a LEFT JOIN l84jw_hikashop_cart_product AS b ON a.cart_id = b.cart_id LEFT JOIN l84jw_hikashop_product AS c ON b.product_id=c.product_id WHERE b.cart_id = 13 AND b.product_id > 0 ORDER BY b.cart_product_modified ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Using filesort 1 SIMPLE b ref cart_id cart_id 4 const 1 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 priderwr_theright_pr1d3kc0r.b.product_id 1 Profile No SHOW PROFILE (maybe because there are more than 100 queries) Call Stack JROOT/administrator/components/com_hikashop/classes/cart.php:102 JROOT/components/com_hikashop/views/product/view.html.php:1908 JROOT/components/com_hikashop/views/product/view.html.php:37 JROOT/administrator/components/com_hikashop/helpers/helper.php:738 JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:44 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 0.21 ms SELECT currency_id FROM l84jw_hikashop_currency WHERE currency_published=1 OR currency_id = 2 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_hikashop_currency ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 181 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/currency.php:426 JROOT/administrator/components/com_hikashop/classes/cart.php:1122 JROOT/components/com_hikashop/views/product/view.html.php:1909 JROOT/components/com_hikashop/views/product/view.html.php:37 JROOT/administrator/components/com_hikashop/helpers/helper.php:738 JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:44 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.08 ms After last query: 0.21 ms Duplicate queries: #7 #32 SELECT a.*,b.*,c.* FROM l84jw_hikashop_cart AS a LEFT JOIN l84jw_hikashop_cart_product AS b ON a.cart_id = b.cart_id LEFT JOIN l84jw_hikashop_product AS c ON b.product_id=c.product_id WHERE b.cart_id = 13 AND b.product_id > 0 ORDER BY b.cart_product_modified ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Using filesort 1 SIMPLE b ref cart_id cart_id 4 const 1 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 priderwr_theright_pr1d3kc0r.b.product_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 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/cart.php:102 JROOT/administrator/components/com_hikashop/classes/cart.php:1134 JROOT/components/com_hikashop/views/product/view.html.php:1909 JROOT/components/com_hikashop/views/product/view.html.php:37 JROOT/administrator/components/com_hikashop/helpers/helper.php:738 JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:44 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.07 ms After last query: 0.12 ms SELECT a.*, b.* FROM l84jw_hikashop_product_category AS a LEFT JOIN l84jw_hikashop_category AS b ON a.category_id = b.category_id WHERE a.product_id IN(14) ORDER BY a.ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref product_id product_id 4 const 1 Using where; Using filesort 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 priderwr_theright_pr1d3kc0r.a.category_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/administrator/components/com_hikashop/classes/cart.php:1156 JROOT/components/com_hikashop/views/product/view.html.php:1909 JROOT/components/com_hikashop/views/product/view.html.php:37 JROOT/administrator/components/com_hikashop/helpers/helper.php:738 JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:44 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 0.43 ms SELECT * FROM l84jw_hikashop_file WHERE file_ref_id IN (14) AND file_type IN( 'product','file') ORDER BY file_ref_id ASC, file_ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l84jw_hikashop_file ALL file_type NO INDEX KEY COULD BE USED NULL NULL 31 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/cart.php:1183 JROOT/components/com_hikashop/views/product/view.html.php:1909 JROOT/components/com_hikashop/views/product/view.html.php:37 JROOT/administrator/components/com_hikashop/helpers/helper.php:738 JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:44 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40 [Add xdebug.file_link_format directive to your php.ini file to have links for files] Query Time: 0.06 ms After last query: 0.09 ms SELECT a.*,b.* FROM l84jw_hikashop_variant AS a LEFT JOIN l84jw_hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id WHERE a.variant_product_id IN (14) ORDER BY a.ordering,b.characteristic_value 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_hikashop/classes/cart.php:1203 JROOT/components/com_hikashop/views/product/view.html.php:1909 JROOT/components/com_hikashop/views/product/view.html.php:37 JROOT/administrator/components/com_hikashop/helpers/helper.php:738 JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:44 JROOT/libraries/cms/module/helper.php:178 JROOT/libraries/joomla/document/html/renderer/module.php:105 JROOT/libraries/joomla/document/html/renderer/modules.php:46 JROOT/libraries/joomla/document/html/html.php:408 JROOT/libraries/joomla/document/html/html.php:690 JROOT/libraries/joomla/document/html/html.php:471 JROOT/libraries/cms/application/cms.php:999 JROOT/libraries/cms/application/site.php:702 JROOT/libraries/cms/application/cms.php:261 JROOT/index.php:40