Calendar - Pikes Peak Weavers Guild

November 2018 – March 2019

N.	Query	Duration, ms	Row Count
1	SELECT DISTINCT p.*, e.post_id, i.id AS instance_id, i.start AS start, i.end AS end, e.allday AS event_allday, e.recurrence_rules, e.exception_rules, e.ticket_url, e.instant_event, e.recurrence_dates, e.exception_dates, e.venue, e.country, e.address, e.city, e.province, e.postal_code, e.show_map, e.contact_name, e.contact_phone, e.contact_email, e.cost, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.timezone_name, e.longitude, e.latitude FROM wpib_ai1ec_events e INNER JOIN wpib_posts p ON e.post_id = p.ID INNER JOIN wpib_ai1ec_event_instances i ON e.post_id = i.post_id WHERE post_type = 'ai1ec_event' AND i.end >= 1539837741 AND post_status = 'publish' ORDER BY i.start ASC, post_title ASC LIMIT 0, 11	7.55	11
2	SELECT `term_id`, `term_image`, `term_color` FROM `wpib_ai1ec_event_category_meta`	5.53	4
3	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.35	1
4	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.16	1
5	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.16	1
6	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.18	1
7	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.16	1
8	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.15	1
9	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.18	1
10	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.15	1
11	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.18	1
12	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.3	1
13	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.17	1
14	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.21	1
15	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 13 LIMIT 1	0.33	1
16	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 6 LIMIT 1	0.26	1
17	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 9 LIMIT 1	0.12	1
18	SELECT terms_taxonomy.taxonomy FROM wpib_terms AS terms INNER JOIN wpib_term_taxonomy AS terms_taxonomy USING(term_id) WHERE terms.term_id = 7 LIMIT 1	0.22	1
Total time, ms: 16.36

Query

Duration, ms

Row Count

SELECT DISTINCT p.*, e.post_id, i.id AS instance_id, i.start AS start, i.end AS end, e.allday AS event_allday, e.recurrence_rules, e.exception_rules, e.ticket_url, e.instant_event, e.recurrence_dates, e.exception_dates, e.venue, e.country, e.address, e.city, e.province, e.postal_code, e.show_map, e.contact_name, e.contact_phone, e.contact_email, e.cost, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.timezone_name, e.longitude, e.latitude FROM wpib_ai1ec_events e INNER JOIN wpib_posts p ON e.post_id = p.ID INNER JOIN wpib_ai1ec_event_instances i ON e.post_id = i.post_id WHERE post_type = 'ai1ec_event' AND i.end >= 1539837741 AND post_status = 'publish' ORDER BY i.start ASC, post_title ASC LIMIT 0, 11

7.55

SELECT `term_id`, `term_image`, `term_color` FROM `wpib_ai1ec_event_category_meta`

5.53