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
(https://i.postimg.cc/PPX0jFCf/Account-My-SQL-Blueboard-cz.png) (https://postimg.cc/PPX0jFCf)
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;
--------------------------------------------------------------------
Could this be it ?
https://forum.virtuemart.net/index.php?topic=141449.msg500491#msg500491 (https://forum.virtuemart.net/index.php?topic=141449.msg500491#msg500491)
Jörgen @ Kreativ Fotografi
NO :(
Try looking at j39_sh404sef_urls
Does anyone really still use sh404sef??
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.
We do not have this "custname" in the code. I doubt it is a Query which comes from the core
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
Quote from: marvays 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
Around "virtuemart_order_id" i have VM and Artio invoice. not more. Yesterday I turned off Artio Invoice, but no change
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.
Quote from: Milbo 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.
this is Slow queries report onm y hosting.
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;
--------------------------------------------------------------------
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/
And this my category . . . . all its OK?
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