Is there anything you can tell me about this query. it appears to be a long running one slowing down the system perhaps. I recently had a database slowdown, and I am trying to figure out the culprit.
\nthanks<\/p>\n
Count: 1 Time=13.07s (13s) Lock=0.00s (0s) Rows=0.0 (0), database[username]@localhost
\n SELECT DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘S’ ) WHERE N=N AND wp_posts.post_type = ‘S’ AND (wp_posts.post_status = ‘S’) AND (
\n wp_postmeta.meta_key = ‘S’
\n ) AND ((wp_postmeta.meta_value >= ‘S’ AND wp_postmeta.meta_value <= ‘S’) OR (tribe_event_end_date.meta_value >= ‘S’ AND wp_postmeta.meta_value <= ‘S’ ) OR (wp_postmeta.meta_value < ‘S’ AND tribe_event_end_date.meta_value >= ‘S’ )) GROUP BY wp_posts.ID ORDER BY DATE(MIN(wp_postmeta.meta_value)) ASC, TIME(wp_postmeta.meta_value) ASC<\/p>\n","protected":false},"template":"","class_list":["post-936403","topic","type-topic","status-closed","hentry"],"yoast_head":"\n