Advertisement
iGreenie

slow query

Jul 1st, 2015
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. # Time: 150701 9:10:17
  2. # User@Host: ....[....] @ localhost []
  3. # Thread_id: 66165 Schema: database_name QC_hit: No
  4. # Query_time: 26.932625 Lock_time: 0.000145 Rows_sent: 20 Rows_examined: 13899
  5. use database_name;
  6. SET timestamp=1435734617;
  7. SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_eo_events.event_id, wp_eo_events.event_id AS occurrence_id, wp_eo_events.StartDate, wp_eo_events.StartTime, wp_eo_events.EndDate, wp_eo_events.FinishTime, wp_eo_events.event_occurrence FROM wp_posts LEFT JOIN
  8. ( SELECT * FROM wp_eo_events ORDER BY wp_eo_events.StartDate ASC, wp_eo_events.StartTime ASC )
  9. AS wp_eo_events ON wp_posts.id = wp_eo_events.post_id WHERE 1=1 AND wp_posts.post_type = 'event' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'confirmed' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_eo_events.StartDate DESC, wp_eo_events.StartTime DESC LIMIT 0, 20;
  10. # Time: 150701 11:31:18
  11. # User@Host: ...[...] @ localhost []
  12. # Thread_id: 78860 Schema: database_name QC_hit: No
  13. # Query_time: 30.562176 Lock_time: 0.000092 Rows_sent: 20 Rows_examined: 13932
  14. SET timestamp=1435743078;
  15. SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_eo_events.event_id, wp_eo_events.event_id AS occurrence_id, wp_eo_events.StartDate, wp_eo_events.StartTime, wp_eo_events.EndDate, wp_eo_events.FinishTime, wp_eo_events.event_occurrence FROM wp_posts LEFT JOIN
  16. ( SELECT * FROM wp_eo_events ORDER BY wp_eo_events.StartDate ASC, wp_eo_events.StartTime ASC )
  17. AS wp_eo_events ON wp_posts.id = wp_eo_events.post_id WHERE 1=1 AND wp_posts.post_type = 'event' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'confirmed' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_eo_events.StartDate DESC, wp_eo_events.StartTime DESC LIMIT 0, 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement