# Time: 230515 10:39:58
# User@Host: сайт.com.ua[сайт.com.ua] @ localhost []
# Thread_id: 507466 Schema: сайт.com.ua QC_hit: No
# Query_time: 9.271988 Lock_time: 0.000160 Rows_sent: 0 Rows_examined: 1222361
# Rows_affected: 10 Bytes_sent: 11
SET timestamp=1684136398;
DELETE
`oc_order`,
oc_order_product,
oc_order_history,
oc_order_option,
oc_order_total,oc_order_voucher FROM
`oc_order`
LEFT JOIN
oc_order_product
ON
oc_order_product.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_history
ON
oc_order_history.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_option
ON
oc_order_option.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_total
ON
oc_order_total.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_voucher
ON
oc_order_voucher.order_id = `oc_order`.order_id WHERE
`oc_order`.order_id = '69159'
AND
`oc_order`.order_status_id = 0;
# Time: 230515 10:42:39
# User@Host: сайт.com.ua[сайт.com.ua] @ localhost []
# Thread_id: 507926 Schema: сайт.com.ua QC_hit: No
# Query_time: 9.459083 Lock_time: 0.000221 Rows_sent: 0 Rows_examined: 1222377
# Rows_affected: 10 Bytes_sent: 11
SET timestamp=1684136559;
DELETE
`oc_order`,
oc_order_product,
oc_order_history,
oc_order_option,
oc_order_total,oc_order_voucher FROM
`oc_order`
LEFT JOIN
oc_order_product
ON
oc_order_product.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_history
ON
oc_order_history.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_option
ON
oc_order_option.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_total
ON
oc_order_total.order_id = `oc_order`.order_id
LEFT JOIN
oc_order_voucher
ON
oc_order_voucher.order_id = `oc_order`.order_id WHERE
`oc_order`.order_id = '69159'
AND
`oc_order`.order_status_id = 0;
Всем привет! Начал замечать, что при заказе иногда долго обрабатывается запрос (именно в корзине Подтвердить заказ). Поиски привели к медленным запросам БД и логу вот такого содержания (выше).
Не могу понять, что оно удаляет?