Author Topic: Probelm Load chart database  (Read 851 times)

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Probelm Load chart database
« on: April 08, 2019, 22:34:58 pm »
Hi. A few days I have problem with database. Load in database jump up and down. I will exceed 100% a few times a day and the hosting will turn off for 20 minutes.
Where can the problem be? Joomla 3.9.4 and VM 3.4.2



Code: [Select]
Databaze: 23045_j39
Trvání dotazu: 0.479687 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.424651 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.419245 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.389323 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.374936 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.371587 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.357397 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.349409 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.268222 s
Dotaz: # Rows_affected: 1
UPDATE `j39_sh404sef_urls` SET `cpt`=176, `last_hit`='2019-04-08 08:46:59' WHERE `id`='64160' AND `rank`=0;

--------------------------------------------------------------------

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2461
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Probelm Load chart database
« Reply #1 on: April 09, 2019, 06:53:14 am »
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Re: Probelm Load chart database
« Reply #2 on: April 09, 2019, 08:04:47 am »
NO :(

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3025
  • VirtueMart Version: 3.6.3
Re: Probelm Load chart database
« Reply #3 on: April 09, 2019, 10:14:10 am »
Try looking at j39_sh404sef_urls

Does anyone really still use sh404sef??
regards
A

Joomla 3.9.12
php 7.2

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Re: Probelm Load chart database
« Reply #4 on: April 09, 2019, 10:23:04 am »
Yes, i have it. but look into my "code" . . . . SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
      vo.`order_number`  . . . .

all around virtuemart order.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Probelm Load chart database
« Reply #5 on: April 10, 2019, 10:04:37 am »
We do not have this "custname"  in the code. I doubt it is a Query which comes from the core
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Re: Probelm Load chart database
« Reply #6 on: April 10, 2019, 10:06:44 am »
Thanks for the information. Now just find out where it came from :)
I created a copy of the site with debug mode.
https://luky.andree-andree.cz

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Re: Probelm Load chart database
« Reply #7 on: April 10, 2019, 10:09:05 am »
Thanks for the information. Now just find out where it came from :)
I created a copy of the site with debug mode.
https://luky.andree-andree.cz
Around "virtuemart_order_id" i have VM and Artio invoice. not more. Yesterday I turned off Artio Invoice, but no change

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Probelm Load chart database
« Reply #8 on: April 10, 2019, 10:13:43 am »
where does it appear, on which page? which action? we use for example only one time the CONCAT_WS, but as you can see in upper case and the prefix is the u. not vu.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Re: Probelm Load chart database
« Reply #9 on: April 10, 2019, 10:27:04 am »
where does it appear, on which page? which action? we use for example only one time the CONCAT_WS, but as you can see in upper case and the prefix is the u. not vu.

this is Slow queries report onm y hosting.
Code: [Select]
Databaze: 22772_luky
Datum a čas dotazu: 10. 4. v 05:58
Trvání dotazu: 0.375646 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 22772_luky
Datum a čas dotazu: 10. 4. v 05:59
Trvání dotazu: 0.359899 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 22772_luky
Datum a čas dotazu: 10. 4. v 05:58
Trvání dotazu: 0.355607 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

Databaze: 22772_luky
Datum a čas dotazu: 10. 4. v 05:23
Trvání dotazu: 0.353935 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` ,
vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
v.`created_by` ,
vendor.`name` AS vendorname ,
vos.`order_status_name`
FROM `j39_virtuemart_orders` vo
LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT' 
LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id`
LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by`
LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status`
ORDER BY vo.`created_on` DESC
LIMIT 50;

--------------------------------------------------------------------

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Re: Probelm Load chart database
« Reply #10 on: April 10, 2019, 12:20:30 pm »
my host provider says:

In DB, the problem is not, the peak in the load had to be caused by something that is not normally done.
The last time we dealt with it was a problem in one of the plugins, then you found out about it. Problems occur when there is more than one person on the web and if the site is overloaded with this almost zero traffic, it is really very bad.

Very slow are the filter pages and are often visited by search engines by log

https://www.webpagetest.org/result/190410_5N_96692f57c3b96d16048a82a02cf923bc/

marvays

  • Jr. Member
  • **
  • Posts: 244
    • http://marvays.cz
  • Skype Name: marvays
Re: Probelm Load chart database
« Reply #11 on: April 10, 2019, 13:12:48 pm »
And this my category . . . . all its OK?
Code: [Select]
98 zaznamenaných typů dotazu, řazeno dle výskytu
VYBRANÉ tabulky:
47 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,   c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,   field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`   
  FROM `j39_virtuemart_customs` AS c
  LEFT JOIN `j39_virtuemart_product_customfields` AS field
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
40 × SELECT slug
  FROM j39_virtuemart_categories_cs_cz
35 × SELECT *
  FROM `j39_virtuemart_product_prices`
35 × SELECT *
  FROM `j39_virtuemart_product_categories`
35 × SELECT `virtuemart_manufacturer_id`
  FROM `j39_virtuemart_product_manufacturers`
35 × SELECT `virtuemart_shoppergroup_id`
  FROM `j39_virtuemart_product_shoppergroups`
35 × SELECT `virtuemart_media_id`
  FROM `j39_virtuemart_product_medias`
35 × SELECT `j39_virtuemart_products`.* ,`j39_virtuemart_products_cs_cz`.* 
  FROM `j39_virtuemart_products`
  INNER JOIN `j39_virtuemart_products_cs_cz` using (`virtuemart_product_id`)
34 × SELECT `j39_virtuemart_medias`.* 
  FROM `j39_virtuemart_medias`
34 × SELECT `j39_virtuemart_ratings`.* 
  FROM `j39_virtuemart_ratings`
22 × SELECT DISTINCT cfp.customfield_value AS id,cfp.customfield_value AS name
  FROM j39_virtuemart_product_customfields AS cfp
  INNER JOIN `j39_virtuemart_products` AS p
  ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
  INNER JOIN j39_virtuemart_product_categories
  ON p.virtuemart_product_id = j39_virtuemart_product_categories.virtuemart_product_id
12 × SELECT `j39_virtuemart_categories`.* ,`j39_virtuemart_categories_cs_cz`.* 
  FROM `j39_virtuemart_categories`
  INNER JOIN `j39_virtuemart_categories_cs_cz` using (`virtuemart_category_id`)
8 × SELECT `j39_virtuemart_manufacturers`.* ,`j39_virtuemart_manufacturers_cs_cz`.* 
  FROM `j39_virtuemart_manufacturers`
  INNER JOIN `j39_virtuemart_manufacturers_cs_cz` using (`virtuemart_manufacturer_id`)
4 × select *
  from `j39_onepage_config`
3 × SELECT *
  FROM j39_virtuemart_calcs 
  LEFT JOIN j39_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
3 × SELECT cf.id AS id,cf.type_id  AS disp_type,cf.params AS params,cf.data_type AS data_type,vmc.virtuemart_custom_id AS custom_id,vmc.custom_title AS custom_title,vmc.custom_element AS custom_element,vmc.field_type AS field_type,vmc.is_list, vmc.custom_value
  FROM j39_cf_customfields AS cf
  INNER JOIN j39_virtuemart_customs AS vmc
  ON cf.vm_custom_id=vmc.virtuemart_custom_id
3 × SELECT `data`
  FROM `j39_session`
3 × SELECT `params`, `parent_id`
  FROM `j39_vminvoice3_config`
2 × SELECT *
  FROM j39_jsn_mobilize_os
2 × SELECT slug
  FROM j39_virtuemart_manufacturers_cs_cz
2 × SELECT `manifest_cache`
  FROM `j39_extensions`
2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
  FROM j39_fields AS a
  LEFT JOIN `j39_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN j39_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN j39_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN j39_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN j39_fields_groups AS g
  ON g.id = a.group_id
2 × SELECT *
  FROM `j39_virtuemart_userfields`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `j39_extensions`
2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  j39_virtuemart_category_categories AS `xref`
2 × SELECT l.slug 
  FROM `j39_virtuemart_manufacturers_cs_cz` as l
2 × SELECT *
  FROM j39_jsn_mobilize_design
2 × SELECT *
  FROM j39_jsn_mobilize_profiles AS p
  INNER JOIN j39_jsn_mobilize_os_support AS s
  ON s.profile_id = p.profile_id
1 × SELECT *
  FROM `j39_menu`
1 × SELECT `g`.`id`,`g`.`title`
  FROM `j39_usergroups` AS g
  INNER JOIN `j39_user_usergroup_map` AS m
  ON m.group_id = g.id
1 × SELECT `value`
  FROM `j39_admintools_storage`
1 × SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug
  FROM j39_virtuemart_categories as c 
  LEFT JOIN `j39_virtuemart_categories_cs_cz` as l
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
  LEFT JOIN `j39_virtuemart_category_categories` as cx
  on c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT *
  FROM j39_languages
1 × SELECT `j39_virtuemart_vendors`.* ,`j39_virtuemart_vendors_cs_cz`.* 
  FROM `j39_virtuemart_vendors`
  INNER JOIN `j39_virtuemart_vendors_cs_cz` using (`virtuemart_vendor_id`)
1 × SELECT `virtuemart_media_id`
  FROM `j39_virtuemart_vendor_medias`
1 × select b.*
  from j39_rstbox b
1 × SELECT COUNT(id)
  FROM `j39_rstbox_logs`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM j39_modules AS m
  LEFT JOIN j39_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN j39_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
1 × SELECT a.*
  FROM `j39_quix_collections` AS `a`
1 × SELECT title
  FROM j39_usergroups
1 × SELECT *
  FROM `j39_users`
1 × SELECT *
  FROM j39_quix_imgstats
1 × SELECT c.id AS id, a.name AS asset_name
  FROM ( SELECT id,asset_id
  FROM j39_categories
1 × SELECT `virtuemart_manufacturer_id`
  FROM j39_virtuemart_calc_manufacturers
1 × SELECT `config`
  FROM `j39_virtuemart_configs`
1 × SELECT virtuemart_shoppergroup_id
  FROM j39_virtuemart_vmuser_shoppergroups
1 × SELECT SUM(
  CASE WHEN p.product_parent_id=0 THEN 1 ELSE 0 END) AS counter,langt.mf_name AS name,vm.virtuemart_manufacturer_id AS id
  FROM j39_virtuemart_manufacturers AS vm
  LEFT JOIN j39_virtuemart_product_manufacturers
  ON vm.virtuemart_manufacturer_id=j39_virtuemart_product_manufacturers.virtuemart_manufacturer_id
  INNER JOIN `j39_virtuemart_products` AS p
  ON j39_virtuemart_product_manufacturers.virtuemart_product_id = p.`virtuemart_product_id`
  LEFT JOIN j39_virtuemart_manufacturers_cs_cz AS langt
  ON vm.virtuemart_manufacturer_id=langt.virtuemart_manufacturer_id
  INNER JOIN j39_virtuemart_product_categories
  ON p.virtuemart_product_id = j39_virtuemart_product_categories.virtuemart_product_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
  FROM j39_extensions
1 × SELECT CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency`
  FROM `j39_virtuemart_vendors`
1 × SELECT currency_symbol, currency_decimal_place, currency_decimal_symbol,currency_positive_style
  FROM j39_virtuemart_currencies
1 × SELECT b.id
  FROM j39_usergroups AS a
  LEFT JOIN j39_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
1 × SELECT fields, props
  FROM j39_offlajn_forms
1 × SELECT id, rules
  FROM `j39_viewlevels
1 × SELECT * 
  FROM j39_jmap_metainfo
1 × SELECT * 
  FROM j39_jmap_headings
1 × SELECT *
  FROM `j39_admintools_wafexceptions`
1 × SELECT `virtuemart_state_id`
  FROM j39_virtuemart_calc_states
1 × SELECT id, home, template, s.params
  FROM j39_template_styles as s
  LEFT JOIN j39_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
1 × SELECT params
  FROM j39_extensions
1 × SELECT `virtuemart_media_id`
  FROM `j39_virtuemart_category_medias`
1 × SELECT `category_child_id`   
  FROM `j39_virtuemart_category_categories`
1 × SELECT count(`p`.virtuemart_product_id) AS total   
  FROM `j39_virtuemart_product_categories` as `pc`   
  LEFT JOIN `j39_virtuemart_products` as `p`
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
1 × SELECT c.*
  FROM j39_virtuemart_customs  as c
  INNER JOIN j39_virtuemart_product_customfields as pc
  on (c.virtuemart_custom_id=pc.virtuemart_custom_id)
  INNER JOIN j39_virtuemart_product_categories as cat
  ON (pc.virtuemart_product_id=cat.virtuemart_product_id)
1 × SELECT *
  FROM `j39_virtuemart_shoppergroups`
1 × SELECT `j39_virtuemart_shoppergroups`.* 
  FROM `j39_virtuemart_shoppergroups`
1 × SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price     
  FROM `j39_virtuemart_products` as p     
  LEFT JOIN `j39_virtuemart_product_shoppergroups` as ps
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`   
  LEFT JOIN `j39_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`   
  LEFT JOIN `j39_virtuemart_product_prices` as pp
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
1 × SELECT FOUND_ROWS(
1 × SELECT DISTINCT  l.virtuemart_manufacturer_id, l.mf_name 
  FROM `j39_virtuemart_manufacturers_cs_cz` as l 
  INNER JOIN `j39_virtuemart_product_manufacturers` AS pm
  ON pm.`virtuemart_manufacturer_id` = l.`virtuemart_manufacturer_id` 
  INNER JOIN `j39_virtuemart_products` as p
  ON p.`virtuemart_product_id` = pm.`virtuemart_product_id` 
  INNER JOIN `j39_virtuemart_product_categories` as pc
  ON pc.`virtuemart_product_id` = pm.`virtuemart_product_id`
1 × select config_subname
  from j39_onepage_config
1 × select `enabled`
  from `j39_extensions`
1 × SELECT name,value
  FROM j39_jsn_mobilize_config
1 × SELECT `source`,`keepurlparams`
  FROM `j39_admintools_redirects`
1 × SELECT `virtuemart_country_id`
  FROM j39_virtuemart_calc_countries
1 × select `config_subname`, `value`
  from j39_onepage_config
1 × SELECT template
  FROM j39_template_styles
1 × SELECT *
  FROM j39_extensions
1 × SELECT `extension_id`
  FROM `j39_extensions`
1 × SELECT *
  FROM j39_gsd_config
1 × SELECT * 
  FROM `j39_virtuemart_currencies` AS c   
  LEFT JOIN `j39_virtuemart_vendors` AS v
  ON  c.virtuemart_currency_id = v.vendor_currency
1 × SELECT `j39_virtuemart_currencies`.* 
  FROM `j39_virtuemart_currencies`
1 × SELECT `id`,`name`,`rules`,`parent_id`
  FROM `j39_assets`
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 j39_menu AS m
  LEFT JOIN j39_extensions AS e
  ON m.component_id = e.extension_id
1 × SELECT c.*
  FROM j39_virtuemart_calcs as c 
  LEFT JOIN j39_virtuemart_calc_shoppergroups as cs
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id
1 × SELECT `virtuemart_category_id`
  FROM j39_virtuemart_calc_categories
1 × SELECT `virtuemart_shoppergroup_id`
  FROM j39_virtuemart_calc_shoppergroups
1 × SELECT * 
  FROM `j39_virtuemart_countries`
JINÉ tabulky:
1 × SHOW FULL COLUMNS
  FROM `j39_gsd_config
1 × SHOW FULL COLUMNS
  FROM `j39_extensions
1 × SHOW VARIABLES LIKE "collation_database
1 × UPDATE `j39_extensions`
  SET `params` = '{\"mediaversion\":\"53f4e80a1942b38eb2fad21a7a20ab52\"}'
1 × SHOW TABLE
1 × SHOW TABLES LIKE 'j39_onepage_config
1 × SHOW TABLES LIKE "j39_virtuemart_configs
1 × SHOW FULL COLUMNS 
  FROM `j39_virtuemart_userfields
1 × SHOW FULL COLUMNS
  FROM `j39_users
1 × UPDATE `j39_session`
  SET `data` = 'ologin|a:1:{s:7:\"regpage\";s:4:\"auto\";}joomla|s:2536:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjM6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjo2OntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aTozO3M6NToidG9rZW4iO3M6MzI6IjFndlBQcXpESnN6eUxrM1hJY2l3bXdZZ2hEakZTaUZsIjtzOjU6InRpbWVyIjtPOjg6InN0ZENsYXNzIjozOntzOjU6InN0YXJ0IjtpOjE1NTQ4OTM4MjE7czo0OiJsYXN0IjtpOjE1NTQ4OTM4MjE7czozOiJub3ciO2k6MTU1NDg5NDEwMzt9fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6Mzp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9czo0OiJ1c2VyIjtPOjIwOiJKb29tbGFcQ01TXFVzZXJcVXNlciI6MTp7czoyOiJpZCI7aTowO31zOjEwOiJkaXNhYmxlb3BjIjtiOjA7czoyMDoianNuX21vYmlsaXplX3Byb2ZpbGUiO086ODoic3RkQ2xhc3MiOjEwOntzOjEwOiJwcm9maWxlX2lkIjtzOjE6IjQiO3M6MTM6InByb2ZpbGVfdGl0bGUiO3M6ODoiTW9iaWxuw60iO3M6MTk6InByb2ZpbGVfZGVzY3JpcHRpb24iO3M6MDoiIjtzOjEzOiJwcm9maWxlX3N0YXRlIjtzOjE6IjEiO3M6MTQ6InByb2ZpbGVfbWluaWZ5IjtzOjA6IiI7czoyMzoicHJvZmlsZV9vcHRpbWl6ZV9pbWFnZXMiO3M6MToiMCI7czo4OiJvcmRlcmluZyI7czoxOiIwIjtzOjE0OiJwcm9maWxlX2RldmljZSI7czoxMDoianNuX21vYmlsZSI7czoxMDoic3VwcG9ydF9pZCI7czo0OiIyNjc2IjtzOjU6Im9zX2lkIjtzOjI6IjExIjt9czoxOToib3BjX2JlZm9yZV9wYXltZW50XyI7Tjt9czo1OiJfX29wYyI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNToibGFzdGNvbnRpdWVsaW5rIjtzOjgyOiJpbmRleC5waHA/b3B0aW9uPWNvbV92aXJ0dWVtYXJ0JnZpZXc9Y2F0ZWdvcnkmdmlydHVlbWFydF9jYXRlZ29yeV9pZD02OCZJdGVtaWQ9Njc1Ijt9czo0OiJfX3ZtIjtPOjg6InN0ZENsYXNzIjo1OntzOjY6Im1hbmFnZSI7aTowO3M6MTk6InZtbGFzdHZpc2l0ZWRJdGVtaWQiO2k6Njc1O3M6MjM6InZtbGFzdHZpc2l0ZWRjYXRlZ29yeWlkIjtpOjY4O3M6MTk6InZtbGFzdHZpc2l0ZWRtYW51aWQiO2k6MDtzOjY6InZtY2FydCI7czo2MzM6InsiY2FydFByb2R1Y3RzRGF0YSI6W10sInZlbmRvcklkIjowLCJsYXN0VmlzaXRlZENhdGVnb3J5SWQiOjAsInZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiOjAsInZpcnR1ZW1hcnRfcGF5bWVudG1ldGhvZF9pZCI6MCwiYXV0b21hdGljU2VsZWN0ZWRTaGlwbWVudCI6ZmFsc2UsImF1dG9tYXRpY1NlbGVjdGVkUGF5bWVudCI6ZmFsc2UsIm9yZGVyX251bWJlciI6bnVsbCwiQlQiOjAsIlNUIjowLCJjYXJ0ZmllbGRzIjpudWxsLCJjb3Vwb25Db2RlIjoiIiwiX3RyaWVzVmFsaWRhdGVDb3Vwb24iOltdLCJvcmRlcl9sYW5ndWFnZSI6ImNzLUNaIiwicHJpY2VzQ3VycmVuY3kiOiIzMyIsInBheW1lbnRDdXJyZW5jeSI6bnVsbCwiX2d1ZXN0IjoxLCJfaW5DaGVja091dCI6ZmFsc2UsIl9pbkNvbmZpcm0iOmZhbHNlLCJfcmVkaXJlY3RlZCI6ZmFsc2UsIl9kYXRhVmFsaWRhdGVkIjpmYWxzZSwiX2NvbmZpcm1Eb25lIjpmYWxzZSwiU1RzYW1lQXNCVCI6MSwic2VsZWN0ZWRfc2hpcHRvIjowLCJfZnJvbUNhcnQiOmZhbHNlLCJsYXlvdXQiOiJkZWZhdWx0IiwibGF5b3V0UGF0aCI6IiIsInZpcnR1ZW1hcnRfY2FydF9pZCI6MCwib3JkZXJkb25lSHRtbCI6ZmFsc2UsInZpcnR1ZW1hcnRfb3JkZXJfaWQiOmZhbHNlfSI7fX1zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO30=\";'  , `time` = 1554894463
1 × UPDATE `j39_session`
  SET `data` = 'ologin|a:1:{s:7:\"regpage\";s:4:\"auto\";}joomla|s:2536:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjM6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjo2OntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aTo0O3M6NToidG9rZW4iO3M6MzI6IjFndlBQcXpESnN6eUxrM1hJY2l3bXdZZ2hEakZTaUZsIjtzOjU6InRpbWVyIjtPOjg6InN0ZENsYXNzIjozOntzOjU6InN0YXJ0IjtpOjE1NTQ4OTM4MjE7czo0OiJsYXN0IjtpOjE1NTQ4OTQxMDM7czozOiJub3ciO2k6MTU1NDg5NDQ2Mjt9fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6Mzp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9czo0OiJ1c2VyIjtPOjIwOiJKb29tbGFcQ01TXFVzZXJcVXNlciI6MTp7czoyOiJpZCI7aTowO31zOjEwOiJkaXNhYmxlb3BjIjtiOjA7czoyMDoianNuX21vYmlsaXplX3Byb2ZpbGUiO086ODoic3RkQ2xhc3MiOjEwOntzOjEwOiJwcm9maWxlX2lkIjtzOjE6IjQiO3M6MTM6InByb2ZpbGVfdGl0bGUiO3M6ODoiTW9iaWxuw60iO3M6MTk6InByb2ZpbGVfZGVzY3JpcHRpb24iO3M6MDoiIjtzOjEzOiJwcm9maWxlX3N0YXRlIjtzOjE6IjEiO3M6MTQ6InByb2ZpbGVfbWluaWZ5IjtzOjA6IiI7czoyMzoicHJvZmlsZV9vcHRpbWl6ZV9pbWFnZXMiO3M6MToiMCI7czo4OiJvcmRlcmluZyI7czoxOiIwIjtzOjE0OiJwcm9maWxlX2RldmljZSI7czoxMDoianNuX21vYmlsZSI7czoxMDoic3VwcG9ydF9pZCI7czo0OiIyNjc2IjtzOjU6Im9zX2lkIjtzOjI6IjExIjt9czoxOToib3BjX2JlZm9yZV9wYXltZW50XyI7Tjt9czo1OiJfX29wYyI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNToibGFzdGNvbnRpdWVsaW5rIjtzOjgyOiJpbmRleC5waHA/b3B0aW9uPWNvbV92aXJ0dWVtYXJ0JnZpZXc9Y2F0ZWdvcnkmdmlydHVlbWFydF9jYXRlZ29yeV9pZD02OCZJdGVtaWQ9Njc1Ijt9czo0OiJfX3ZtIjtPOjg6InN0ZENsYXNzIjo1OntzOjY6Im1hbmFnZSI7aTowO3M6MTk6InZtbGFzdHZpc2l0ZWRJdGVtaWQiO2k6Njc1O3M6MjM6InZtbGFzdHZpc2l0ZWRjYXRlZ29yeWlkIjtpOjY4O3M6MTk6InZtbGFzdHZpc2l0ZWRtYW51aWQiO2k6MDtzOjY6InZtY2FydCI7czo2MzM6InsiY2FydFByb2R1Y3RzRGF0YSI6W10sInZlbmRvcklkIjowLCJsYXN0VmlzaXRlZENhdGVnb3J5SWQiOjAsInZpcnR1ZW1hcnRfc2hpcG1lbnRtZXRob2RfaWQiOjAsInZpcnR1ZW1hcnRfcGF5bWVudG1ldGhvZF9pZCI6MCwiYXV0b21hdGljU2VsZWN0ZWRTaGlwbWVudCI6ZmFsc2UsImF1dG9tYXRpY1NlbGVjdGVkUGF5bWVudCI6ZmFsc2UsIm9yZGVyX251bWJlciI6bnVsbCwiQlQiOjAsIlNUIjowLCJjYXJ0ZmllbGRzIjpudWxsLCJjb3Vwb25Db2RlIjoiIiwiX3RyaWVzVmFsaWRhdGVDb3Vwb24iOltdLCJvcmRlcl9sYW5ndWFnZSI6ImNzLUNaIiwicHJpY2VzQ3VycmVuY3kiOiIzMyIsInBheW1lbnRDdXJyZW5jeSI6bnVsbCwiX2d1ZXN0IjoxLCJfaW5DaGVja091dCI6ZmFsc2UsIl9pbkNvbmZpcm0iOmZhbHNlLCJfcmVkaXJlY3RlZCI6ZmFsc2UsIl9kYXRhVmFsaWRhdGVkIjpmYWxzZSwiX2NvbmZpcm1Eb25lIjpmYWxzZSwiU1RzYW1lQXNCVCI6MSwic2VsZWN0ZWRfc2hpcHRvIjowLCJfZnJvbUNhcnQiOmZhbHNlLCJsYXlvdXQiOiJkZWZhdWx0IiwibGF5b3V0UGF0aCI6IiIsInZpcnR1ZW1hcnRfY2FydF9pZCI6MCwib3JkZXJkb25lSHRtbCI6ZmFsc2UsInZpcnR1ZW1hcnRfb3JkZXJfaWQiOmZhbHNlfSI7fX1zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO30=\";'  , `time` = 1554894463
1 × COMMI