Add/remove item in cart module goes to blank page

Start
Prev
1
Next
End
vaneinxs
Topic Author
Offline
Posts: 7
Thank you received: 0
9 years 10 months ago #187047
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.2.2
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : blank page with no error message MYDOMAIN.COM/product/updatecart (I have error message enabled)

When i add/remove items from cart module it redirects me to a blank page with no error message MYDOMAIN.COM/product/updatecart (I have error message enabled)
I have these configurations enabled:
for "After a product is added to the cart": Stay anddisplay a popup notice
for "URL where you will be redirected when the cart is empty": MYDOMAIN url
for "Use AJAX when possible for add to cart buttons": Yes
I serched in forum for similar issues but couldn't find an answer. Please help.
Please Log in or Create an account to join the conversation.
Jerome
Offline
HikaShop core developer
Posts: 26158
Thank you received: 4028
MODERATOR
9 years 10 months ago #187050
Hi,

Can you please check your PHP error log in order to be sure that there is no error ?

Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Please Log in or Create an account to join the conversation.
vaneinxs
Topic Author
Offline
Posts: 7
Thank you received: 0
9 years 10 months ago #187082
Hi,
It shows no error at all
Please Log in or Create an account to join the conversation.
nicolas
Online
Posts: 82863
Thank you received: 13372
MODERATOR
9 years 10 months ago #187090
Hi,

Can you turn off the "Use AJAX when possible for add to cart buttons" option and try again ? Do you still have the issue ?
If yes, can you also turn on the "debug mode" and "error reporting" options of the Joomla configuration and try again ? Do you still any error message displayed on the page at that point ?
Please Log in or Create an account to join the conversation.
vaneinxs
Topic Author
Offline
Posts: 7
Thank you received: 0
9 years 10 months ago #187148
well. if I turn off Ajax when I click on "add to cart" on any product it redirects to the same blank page. I left it with ajax off and turn on the debug mode. it tells this!:
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
Last edit: 9 years 10 months ago by Jerome. Reason: [code] is nice
Please Log in or Create an account to join the conversation.
vaneinxs
Topic Author
Offline
Posts: 7
Thank you received: 0
9 years 10 months ago #187182
I solved it by reinstalling! seems a plugin was missing! It works perfect now!
Please Log in or Create an account to join the conversation.
Jerome
Offline
HikaShop core developer
Posts: 26158
Thank you received: 4028
MODERATOR
9 years 10 months ago #187201
Hi,

Thanks for the feedback.
It will help us for a proper fix for the next release.

Regards,
Please Log in or Create an account to join the conversation.
Start
Prev
1
Next
End
Time to create page: 0.100 seconds