Konsola diagnostyczna Joomla!

Informacje o wydajności

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.345 MB / 0.34 MB Application: afterLoad

Time: 31.9 ms / 31.9 ms Memory: 1.863 MB / 2.21 MB Application: afterInitialise

Time: 26.2 ms / 58.1 ms Memory: 2.631 MB / 4.84 MB Application: afterRoute

Time: 95.4 ms / 153.5 ms Memory: 5.532 MB / 10.37 MB Application: afterDispatch

Time: 11.3 ms / 164.8 ms Memory: 0.287 MB / 10.66 MB Application: beforeRenderModule mod_acymailing (NEWSLETTER)

Time: 11.2 ms / 176.0 ms Memory: 0.574 MB / 11.23 MB Application: afterRenderModule mod_acymailing (NEWSLETTER)

Time: 0.1 ms / 176.2 ms Memory: 0.000 MB / 11.21 MB Application: beforeRenderModule mod_menu (INFORMACJE)

Time: 6.1 ms / 182.3 ms Memory: 0.087 MB / 11.30 MB Application: afterRenderModule mod_menu (INFORMACJE)

Time: 0.1 ms / 182.4 ms Memory: 0.000 MB / 11.29 MB Application: beforeRenderModule mod_menu (MENU UŻYTKOWNIKA)

Time: 3.9 ms / 186.3 ms Memory: 0.025 MB / 11.32 MB Application: afterRenderModule mod_menu (MENU UŻYTKOWNIKA)

Time: 0.1 ms / 186.4 ms Memory: 0.000 MB / 11.31 MB Application: beforeRenderModule mod_custom (SZYBKI KONTAKT)

Time: 2.6 ms / 188.9 ms Memory: 0.010 MB / 11.32 MB Application: afterRenderModule mod_custom (SZYBKI KONTAKT)

Time: 0.1 ms / 189.1 ms Memory: 0.000 MB / 11.32 MB Application: beforeRenderModule mod_breadcrumbs (BREADCRUMBS)

Time: 2.8 ms / 191.9 ms Memory: 0.020 MB / 11.34 MB Application: afterRenderModule mod_breadcrumbs (BREADCRUMBS)

Time: 0.1 ms / 192.0 ms Memory: 0.000 MB / 11.34 MB Application: beforeRenderModule mod_virtuemart_search (SZUKAJ)

Time: 7.3 ms / 199.4 ms Memory: 0.102 MB / 11.44 MB Application: afterRenderModule mod_virtuemart_search (SZUKAJ)

Time: 0.2 ms / 199.6 ms Memory: 0.000 MB / 11.44 MB Application: beforeRenderModule mod_languages (JĘZYKI)

Time: 5.2 ms / 204.8 ms Memory: 0.128 MB / 11.56 MB Application: afterRenderModule mod_languages (JĘZYKI)

Time: 0.2 ms / 205.0 ms Memory: 0.005 MB / 11.57 MB Application: beforeRenderModule mod_js_social_tabs_slider (Techto.pl)

Time: 1.1 ms / 206.1 ms Memory: 0.026 MB / 11.60 MB Application: afterRenderModule mod_js_social_tabs_slider (Techto.pl)

Time: 0.1 ms / 206.2 ms Memory: 0.000 MB / 11.58 MB Application: beforeRenderModule mod_running_text (TEXT PL)

Time: 0.4 ms / 206.6 ms Memory: 0.013 MB / 11.60 MB Application: afterRenderModule mod_running_text (TEXT PL)

Time: 120.2 ms / 326.8 ms Memory: 0.362 MB / 11.96 MB Application: afterRender

Database queries total: 22.5 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_session	const	PRIMARY	PRIMARY	602	const	1	Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	352	Using where; Using filesort

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	219	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

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	119	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	serwer100271_techt2.m.component_id	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	9	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	152	serwer100271_techt2.e.element	1	Using index condition; Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	133	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_configs	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	219	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_rokcandy	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	35	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	4	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	2	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	2	const	1

EXPLAIN not possible on query: UPDATE `shop_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685286523;s:18:\"session.timer.last\";i:1685286523;s:17:\"session.timer.now\";i:1685286523;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__vm|a:2:{s:6:\"manage\";i:0;s:6:\"vmcart\";s:561:\"{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"pl-PL\",\"pricesCurrency\":114,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":true,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}\";}' , `time` = '1685286523' WHERE `session_id` = 'aepueajok9203tk3f22ri70up5'

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.0 ms
Updating	0.1 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:85

JROOT/components/com_virtuemart/helpers/cart.php:364

JROOT/components/com_virtuemart/helpers/cart.php:913

JROOT/components/com_virtuemart/controllers/cart.php:107

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.28 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 9.513 MB Rows returned: 1

Duplicate queries: #1

SELECT `data`

  FROM `shop_session`

  WHERE `session_id` = 'aepueajok9203tk3f22ri70up5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_session	const	PRIMARY	PRIMARY	602	const	1

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:46

JROOT/components/com_virtuemart/helpers/cart.php:365

JROOT/components/com_virtuemart/helpers/cart.php:913

JROOT/components/com_virtuemart/controllers/cart.php:107

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.26 ms After last query: 0.27 ms Query memory: 0.029 MB Memory before query: 9.578 MB Rows returned: 1

SELECT `shop_virtuemart_vendors`.* ,`shop_virtuemart_vendors_pl_pl`.*  
  FROM `shop_virtuemart_vendors` 
  INNER JOIN `shop_virtuemart_vendors_pl_pl` using (`virtuemart_vendor_id`) 
  WHERE `shop_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_vendors	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	shop_virtuemart_vendors_pl_pl	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1014

JROOT/administrator/components/com_virtuemart/models/vendor.php:86

JROOT/components/com_virtuemart/helpers/cart.php:1455

JROOT/components/com_virtuemart/helpers/cart.php:1082

JROOT/components/com_virtuemart/helpers/cart.php:922

JROOT/components/com_virtuemart/controllers/cart.php:107

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.16 ms After last query: 0.77 ms Query memory: 0.020 MB Memory before query: 9.689 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `shop_virtuemart_vendor_medias` 
  WHERE `virtuemart_vendor_id` = "1" 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_vendor_medias	system	virtuemart_vendor_id	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:123

JROOT/administrator/components/com_virtuemart/models/vendor.php:97

JROOT/components/com_virtuemart/helpers/cart.php:1455

JROOT/components/com_virtuemart/helpers/cart.php:1082

JROOT/components/com_virtuemart/helpers/cart.php:922

JROOT/components/com_virtuemart/controllers/cart.php:107

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.22 ms After last query: 0.50 ms Query memory: 0.029 MB Memory before query: 9.785 MB Rows returned: 0

SELECT `shop_virtuemart_medias`.*  
  FROM `shop_virtuemart_medias`  
  WHERE `shop_virtuemart_medias`.`virtuemart_media_id` = "2063"

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
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1014

JROOT/administrator/components/com_virtuemart/models/media.php:99

JROOT/administrator/components/com_virtuemart/models/media.php:400

JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1063

JROOT/components/com_virtuemart/helpers/cart.php:1456

JROOT/components/com_virtuemart/helpers/cart.php:1082

JROOT/components/com_virtuemart/helpers/cart.php:922

JROOT/components/com_virtuemart/controllers/cart.php:107

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.39 ms After last query: 9.48 ms Query memory: 0.027 MB Memory before query: 9.977 MB Rows returned: 2

SELECT * 
  FROM `shop_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `cart`=1 
  AND published = 1 
  AND type != 'delimiter' 
  AND type != 'captcha' 
  AND FIND_IN_SET(name, 'delimiter_userinfo,user_is_vendor,username,password,password2,agreed,address_type') = 0  
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_userfields	ref\|filter	published,cart	cart\|published	1\|1	const	4 (71%)	Using where; Using filesort; Using rowid filter

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490

JROOT/administrator/components/com_virtuemart/models/userfields.php:575

JROOT/components/com_virtuemart/views/cart/view.html.php:107

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.79 ms After last query: 0.81 ms Query memory: 0.031 MB Memory before query: 10.035 MB Rows returned: 0

Duplicate queries: #49

SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id  
  FROM   `shop_virtuemart_paymentmethods_pl_pl` as l  JOIN `shop_virtuemart_paymentmethods` AS v   USING (`virtuemart_paymentmethod_id`)  
  LEFT JOIN `shop_extensions` as j 
  ON j.`extension_id` =  v.`payment_jplugin_id`  
  LEFT 
  OUTER JOIN `shop_virtuemart_paymentmethod_shoppergroups` AS s 
  ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
  WHERE v.`published` = "1" 
  AND j.`element` = "paypal"
	    						
  AND  (v.`virtuemart_vendor_id` = "0" OR v.`virtuemart_vendor_id` = "0" OR v.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY v.`virtuemart_paymentmethod_id` 
  ORDER BY v.`ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	302	const	1	Using index condition; Using temporary; Using filesort
1	SIMPLE	v	ref	PRIMARY,payment_jplugin_id,virtuemart_vendor_id	payment_jplugin_id	4	serwer100271_techt2.j.extension_id	1	Using where
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	serwer100271_techt2.v.virtuemart_paymentmethod_id	1	Using index condition
1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	3	serwer100271_techt2.v.virtuemart_paymentmethod_id	1	Using where; Using index

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.2 ms
Creating sort index	0.0 ms
Removing tmp table	0.1 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:500

JROOT/plugins/vmpayment/paypal/paypal.php:310

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_virtuemart/views/cart/view.html.php:340

JROOT/components/com_virtuemart/views/cart/view.html.php:127

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.33 ms After last query: 0.50 ms Query memory: 0.024 MB Memory before query: 10.091 MB Rows returned: 1

SELECT SQL_CALC_FOUND_ROWS  * 
  FROM `shop_virtuemart_paymentmethods_pl_pl` as l  JOIN `shop_virtuemart_paymentmethods`   USING (`virtuemart_paymentmethod_id`) 
 
  WHERE  `shop_virtuemart_paymentmethods`.`published` = 1
 
 
  ORDER BY ordering DESC 
  LIMIT 0, 12

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using temporary; Using filesort
1	SIMPLE	shop_virtuemart_paymentmethods	eq_ref	PRIMARY	PRIMARY	3	serwer100271_techt2.l.virtuemart_paymentmethod_id	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
Removing tmp table	0.0 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:838

JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:123

JROOT/components/com_virtuemart/views/cart/view.html.php:356

JROOT/components/com_virtuemart/views/cart/view.html.php:156

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

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: 0.07 ms Query memory: 0.019 MB Memory before query: 10.114 MB Rows returned: 1

Duplicate queries: #47

SELECT FOUND_ROWS()

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	No tables used

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:848

JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:123

JROOT/components/com_virtuemart/views/cart/view.html.php:356

JROOT/components/com_virtuemart/views/cart/view.html.php:156

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.15 ms After last query: 0.05 ms Query memory: 0.018 MB Memory before query: 10.131 MB Rows returned: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM shop_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "4"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_paymentmethod_shoppergroups	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	3	const	1	Using index

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:133

JROOT/components/com_virtuemart/views/cart/view.html.php:356

JROOT/components/com_virtuemart/views/cart/view.html.php:156

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.22 ms After last query: 0.46 ms Query memory: 0.024 MB Memory before query: 10.219 MB Rows returned: 1

SELECT SQL_CALC_FOUND_ROWS  * 
  FROM `shop_virtuemart_shipmentmethods_pl_pl` as l  JOIN `shop_virtuemart_shipmentmethods`   USING (`virtuemart_shipmentmethod_id`) 

 
 
  ORDER BY ordering DESC 
  LIMIT 0, 12

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	shop_virtuemart_shipmentmethods	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:838

JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:128

JROOT/components/com_virtuemart/views/cart/view.html.php:381

JROOT/components/com_virtuemart/views/cart/view.html.php:157

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

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: 0.10 ms Query memory: 0.019 MB Memory before query: 10.241 MB Rows returned: 1

Duplicate queries: #44

SELECT FOUND_ROWS()

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	No tables used

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:848

JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:128

JROOT/components/com_virtuemart/views/cart/view.html.php:381

JROOT/components/com_virtuemart/views/cart/view.html.php:157

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.16 ms After last query: 0.07 ms Query memory: 0.018 MB Memory before query: 10.259 MB Rows returned: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM shop_virtuemart_shipmentmethod_shoppergroups 
  WHERE `virtuemart_shipmentmethod_id` = "4"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_shipmentmethod_shoppergroups	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	const	1	Using index

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:137

JROOT/components/com_virtuemart/views/cart/view.html.php:381

JROOT/components/com_virtuemart/views/cart/view.html.php:157

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.40 ms After last query: 7.70 ms Query memory: 0.039 MB Memory before query: 10.378 MB Rows returned: 0

Duplicate queries: #42

SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id  
  FROM   `shop_virtuemart_paymentmethods_pl_pl` as l  JOIN `shop_virtuemart_paymentmethods` AS v   USING (`virtuemart_paymentmethod_id`)  
  LEFT JOIN `shop_extensions` as j 
  ON j.`extension_id` =  v.`payment_jplugin_id`  
  LEFT 
  OUTER JOIN `shop_virtuemart_paymentmethod_shoppergroups` AS s 
  ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
  WHERE v.`published` = "1" 
  AND j.`element` = "paypal"
	    						
  AND  (v.`virtuemart_vendor_id` = "0" OR v.`virtuemart_vendor_id` = "0" OR v.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY v.`virtuemart_paymentmethod_id` 
  ORDER BY v.`ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	302	const	1	Using index condition; Using temporary; Using filesort
1	SIMPLE	v	ref	PRIMARY,payment_jplugin_id,virtuemart_vendor_id	payment_jplugin_id	4	serwer100271_techt2.j.extension_id	1	Using where
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	serwer100271_techt2.v.virtuemart_paymentmethod_id	1	Using index condition
1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	3	serwer100271_techt2.v.virtuemart_paymentmethod_id	1	Using where; Using index

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	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
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:500

JROOT/plugins/vmpayment/paypal/paypal.php:288

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/templates/t3_bs3_blank/html/com_virtuemart/user/login.php:67

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661

JROOT/components/com_virtuemart/helpers/vmview.php:34

JROOT/components/com_virtuemart/views/user/view.html.php:63

JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:47

JROOT/templates/t3_bs3_blank/html/com_virtuemart/cart/default.php:114

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661

JROOT/components/com_virtuemart/helpers/vmview.php:34

JROOT/components/com_virtuemart/views/cart/view.html.php:215

JROOT/components/com_virtuemart/controllers/cart.php:111

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_virtuemart/virtuemart.php:122

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 2.09 ms After last query: 9.40 ms Query memory: 0.026 MB Memory before query: 10.588 MB Rows returned: 9

SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM shop_modules AS m

  LEFT JOIN shop_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN shop_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 <= '2023-05-28 15:08:43') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-28 15:08:43') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 162 OR mm.menuid <= 0) 
  AND m.language IN ('pl-PL','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref\|filter	PRIMARY,published,newsfeeds,idx_language	published\|idx_language	1\|21	const	72 (53%)	Using index condition; Using where; Using filesort; Using rowid filter
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	serwer100271_techt2.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	serwer100271_techt2.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.8 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102

JROOT/libraries/joomla/document/html/html.php:510

JROOT/plugins/system/t3/includes/core/template.php:656

JROOT/templates/t3_bs3_blank/tpls/blocks/topheader.php:15

JROOT/plugins/system/t3/includes/core/template.php:195

JROOT/templates/t3_bs3_blank/tpls/boxedLeftSidebar.php:38

JROOT/plugins/system/t3/includes/core/template.php:219

JROOT/templates/t3_bs3_blank/index.php:34

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:974

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.35 ms After last query: 13.65 ms Query memory: 0.024 MB Memory before query: 11.054 MB Rows returned: 132

SELECT * 
  FROM shop_acymailing_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_acymailing_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	132

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/cpanel.php:17

JROOT/administrator/components/com_acymailing/helpers/helper.php:402

JROOT/administrator/components/com_acymailing/helpers/helper.php:862

JROOT/modules/mod_acymailing/mod_acymailing.php:12

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

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:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.26 ms After last query: 1.31 ms Query memory: 0.022 MB Memory before query: 11.222 MB Rows returned: 1

SELECT * 
  FROM shop_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_acymailing_list	system	typeorderingindex,typeuseridindex	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/list.php:29

JROOT/modules/mod_acymailing/mod_acymailing.php:117

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

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:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.21 ms After last query: 3.72 ms Query memory: 0.031 MB Memory before query: 11.270 MB Rows returned: 1

SELECT extension_id AS id, element AS "option", params, enabled

  FROM shop_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/components/com_content/router.php:37

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

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:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.43 ms After last query: 23.03 ms Query memory: 0.019 MB Memory before query: 11.479 MB Rows returned: 0

SELECT m2.language, m2.id

  FROM shop_menu as m

  INNER JOIN shop_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN shop_associations as a2 
  ON a.key=a2.key

  INNER JOIN shop_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=162

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
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_menus/helpers/menus.php:257

JROOT/modules/mod_languages/helper.php:58

JROOT/modules/mod_languages/mod_languages.php:18

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

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:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.47 ms After last query: 7.44 ms Query memory: 0.027 MB Memory before query: 11.783 MB Rows returned: 1

SELECT extension_id AS id, element AS "option", params, enabled

  FROM shop_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_contact'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/components/com_contact/router.php:37

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/plugins/system/t3/includes/menu/megamenu.php:162

JROOT/plugins/system/t3/includes/renderer/megamenurender.php:84

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.57 ms After last query: 95.31 ms Query memory: 0.014 MB Memory before query: 11.935 MB Rows returned: 1

Duplicate queries: #57

select id, password 
  from shop_users as u join shop_user_usergroup_map as m 
  on u.id = m.user_id  
  where m.group_id in(8)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	index	PRIMARY	PRIMARY	8	NULL	2	Using where; Using index
1	SIMPLE	u	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/spadaj/spadaj.php:147

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:994

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

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: 0.04 ms Query memory: 0.014 MB Memory before query: 11.948 MB Rows returned: 1

Duplicate queries: #56

select id, password 
  from shop_users as u join shop_user_usergroup_map as m 
  on u.id = m.user_id  
  where m.group_id in(8)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	index	PRIMARY	PRIMARY	8	NULL	2	Using where; Using index
1	SIMPLE	u	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	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
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/spadaj/spadaj.php:148

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:994

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.51 ms After last query: 20.82 ms Query memory: 0.003 MB Memory before query: 11.964 MB

UPDATE `shop_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685286523;s:18:\"session.timer.last\";i:1685286523;s:17:\"session.timer.now\";i:1685286523;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4891b4b32cafc7a2e13a69924d9b104c\";}__vm|a:2:{s:6:\"manage\";i:0;s:6:\"vmcart\";s:562:\"{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"pl-PL\",\"pricesCurrency\":114,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}\";}'
	, `time` = '1685286523'

  WHERE `session_id` = 'aepueajok9203tk3f22ri70up5'

Explain

EXPLAIN not possible on query: UPDATE `shop_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685286523;s:18:\"session.timer.last\";i:1685286523;s:17:\"session.timer.now\";i:1685286523;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4891b4b32cafc7a2e13a69924d9b104c\";}__vm|a:2:{s:6:\"manage\";i:0;s:6:\"vmcart\";s:562:\"{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"pl-PL\",\"pricesCurrency\":114,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}\";}' , `time` = '1685286523' WHERE `session_id` = 'aepueajok9203tk3f22ri70up5'

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.1 ms
Updating	0.1 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:85

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

42 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

8 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM shop_extensions

4 × SELECT * 
  FROM shop_virtuemart_calcs  
  LEFT JOIN shop_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

3 × SELECT * 
  FROM `shop_virtuemart_userfields`

```
2 × SELECT FOUND_ROWS(
```

2 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,    j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id  
  FROM   `shop_virtuemart_paymentmethods_pl_pl` as l  JOIN `shop_virtuemart_paymentmethods` AS v   USING (`virtuemart_paymentmethod_id`)  
  LEFT JOIN `shop_extensions` as j 
  ON j.`extension_id` =  v.`payment_jplugin_id`  
  LEFT 
  OUTER JOIN `shop_virtuemart_paymentmethod_shoppergroups` AS s 
  ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`

2 × SELECT `data` 
  FROM `shop_session`

2 × select id, password 
  from shop_users as u join shop_user_usergroup_map as m 
  on u.id = m.user_id

1 × SELECT `shop_virtuemart_vendors`.* ,`shop_virtuemart_vendors_pl_pl`.*  
  FROM `shop_virtuemart_vendors` 
  INNER JOIN `shop_virtuemart_vendors_pl_pl` using (`virtuemart_vendor_id`)

1 × SELECT SQL_CALC_FOUND_ROWS  * 
  FROM `shop_virtuemart_paymentmethods_pl_pl` as l  JOIN `shop_virtuemart_paymentmethods`   USING (`virtuemart_paymentmethod_id`)

1 × SELECT `virtuemart_media_id` 
  FROM `shop_virtuemart_vendor_medias`

1 × SELECT `shop_virtuemart_medias`.*  
  FROM `shop_virtuemart_medias`

1 × SELECT SQL_CALC_FOUND_ROWS  * 
  FROM `shop_virtuemart_shipmentmethods_pl_pl` as l  JOIN `shop_virtuemart_shipmentmethods`   USING (`virtuemart_shipmentmethod_id`)

1 × SELECT * 
  FROM shop_acymailing_list

1 × SELECT m2.language, m2.id 
  FROM shop_menu as m 
  INNER JOIN shop_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN shop_associations as a2 
  ON a.key=a2.key 
  INNER JOIN shop_menu as m2 
  ON a2.id=m2.id

1 × SELECT * 
  FROM shop_acymailing_confi

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM shop_modules AS m 
  LEFT JOIN shop_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN shop_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM shop_virtuemart_shipmentmethod_shoppergroups

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM shop_virtuemart_paymentmethod_shoppergroups

1 × SELECT *  
  FROM `shop_virtuemart_currencies` AS c    , `shop_virtuemart_vendors` AS v

```
1 × SELECT * 
  FROM shop_languages
```

1 × SELECT COUNT(*) 
  FROM `shop_menu`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM shop_menu AS m 
  LEFT JOIN shop_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT folder AS type, element AS name, params 
  FROM shop_extensions

1 × SELECT id, rules 
  FROM `shop_viewlevels

1 × SELECT `session_id` 
  FROM `shop_session`

1 × SELECT b.id 
  FROM shop_usergroups AS a 
  LEFT JOIN shop_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, home, template, s.params 
  FROM shop_template_styles as s 
  LEFT JOIN shop_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT a.rules 
  FROM shop_assets AS a

1 × SELECT * 
  FROM `shop_virtuemart_shoppergroups`

1 × SELECT `shop_virtuemart_shoppergroups`.*  
  FROM `shop_virtuemart_shoppergroups`

```
1 × SELECT * 
  FROM shop_rokcandy
```
```
1 × SELECT * 
  FROM `shop_menu`
```

1 × SELECT b.rules 
  FROM shop_assets AS a 
  LEFT JOIN shop_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `config` 
  FROM `shop_virtuemart_configs`

1 × SELECT `shop_virtuemart_currencies`.*  
  FROM `shop_virtuemart_currencies`

INNE tabele:

1 × UPDATE `shop_session` 
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685286523;s:18:\"session.timer.last\";i:1685286523;s:17:\"session.timer.now\";i:1685286523;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__vm|a:2:{s:6:\"manage\";i:0;s:6:\"vmcart\";s:561:\"{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"pl-PL\",\"pricesCurrency\":114,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":true,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}\";}'  , `time` = '1685286523'

1 × UPDATE `shop_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685286523;s:18:\"session.timer.last\";i:1685286523;s:17:\"session.timer.now\";i:1685286523;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4891b4b32cafc7a2e13a69924d9b104c\";}__vm|a:2:{s:6:\"manage\";i:0;s:6:\"vmcart\";s:562:\"{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"pl-PL\",\"pricesCurrency\":114,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}\";}'  , `time` = '1685286523'

1 × SHOW FULL COLUMNS  
  FROM `shop_virtuemart_userfields

1 × SHOW TABLES LIKE "shop_virtuemart_configs

1 × INSERT INTO `shop_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('aepueajok9203tk3f22ri70up5', 0, '1685286523'

1 × UPDATE `shop_extensions` 
  SET `params` = '{\"mediaversion\":\"50888513778fd6a99cf41baba19c3bc3\"}'

```
1 × DELETE  
  FROM `shop_session`
```

Techto.pl

Formularz kontaktowy

TWOJE DANE

Płatności i Wysyłka

Koszyk zakupów

Add Product to

Informacje o plikach cookie

Konsola diagnostyczna Joomla!

Sesja

__default

__vm

Informacje o wydajności

Time

Memory

Użycie pamięci

Zapytania do bazy danych

58 zapytań zarejestrowanych 22.5 ms

8 duplicate found!

42 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

INNE tabele:

Status	Duration
Starting	0.4 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_calcs	system	virtuemart_vendor_id,published,calc_kind,shared	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	shop_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found