Advertisement
Guest User

faults

a guest
Dec 5th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 KB | None | 0 0
  1. >>> 2019-12-05T08:25:01, UID 1166
  2. Faults:
  3. * Physical memory: 274
  4. SQL Queries:
  5. +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  6. | CMD | Time | SQL-query |
  7. +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  8. | Query | 0 | SELECT COUNT(*) FROM (
  9. SELECT
  10. wpe6_wc_customer_lookup.customer_id
  11. FROM
  12. wpe6_wc_customer_lookup
  13. 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' ) )
  14. WHERE
  15. 1=1
  16. 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')
  17. GROUP BY
  18. wpe6_wc_customer_lookup.customer_id
  19. ) as tt |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement