Where can the problem be? Joomla 3.9.5 and VM 3.4.2
Code: Select all
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;
--------------------------------------------------------------------
Can anyone help me find problem, please?