Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- >>> 2019-12-05T08:25:01, UID 1166
- Faults:
- * Physical memory: 274
- SQL Queries:
- +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | CMD | Time | SQL-query |
- +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Query | 0 | SELECT COUNT(*) FROM (
- SELECT
- wpe6_wc_customer_lookup.customer_id
- FROM
- wpe6_wc_customer_lookup
- LEFT JOIN wpe6_wc_order_stats ON wpe6_wc_customer_lookup.customer_id = wpe6_wc_order_stats.customer_id AND ( wpe6_wc_order_stats.status NOT IN ( 'wc-trash','wc-pending','wc-failed','wc-cancelled' ) )
- WHERE
- 1=1
- AND (wpe6_wc_order_stats.date_created <= '2019-12-05 23:59:59' AND wpe6_wc_order_stats.date_created >= '2019-12-01 00:00:00')
- GROUP BY
- wpe6_wc_customer_lookup.customer_id
- ) as tt |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement