Tamarack District Library Lakeview, Michigan

Growing Minds~Building Communities
N. Query Duration, ms Row Count
1 SELECT e.post_id, e.timezone_name, e.recurrence_rules, e.exception_rules, e.allday, 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.contact_url, e.cost, e.ticket_url, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.longitude, e.latitude, e.show_coordinates, GROUP_CONCAT( ttc.term_id ) AS categories, GROUP_CONCAT( ttt.term_id ) AS tags , IF( aei.start IS NOT NULL, aei.start, e.start ) as start, IF( aei.start IS NOT NULL, aei.end, e.end ) as end FROM tha_ai1ec_events e LEFT JOIN tha_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN tha_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN tha_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) LEFT JOIN tha_ai1ec_event_instances aei ON aei.id = 366 AND e.post_id = aei.post_id WHERE e.post_id = 236 GROUP BY e.post_id 5.77 1
2 SELECT e.post_id, e.timezone_name, e.recurrence_rules, e.exception_rules, e.allday, 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.contact_url, e.cost, e.ticket_url, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.longitude, e.latitude, e.show_coordinates, GROUP_CONCAT( ttc.term_id ) AS categories, GROUP_CONCAT( ttt.term_id ) AS tags , e.start as start, e.end as end, e.allday FROM tha_ai1ec_events e LEFT JOIN tha_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN tha_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN tha_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) WHERE e.post_id = 236 GROUP BY e.post_id 1.71 1
3 SELECT e.post_id, e.timezone_name, e.recurrence_rules, e.exception_rules, e.allday, 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.contact_url, e.cost, e.ticket_url, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.longitude, e.latitude, e.show_coordinates, GROUP_CONCAT( ttc.term_id ) AS categories, GROUP_CONCAT( ttt.term_id ) AS tags , e.start as start, e.end as end, e.allday FROM tha_ai1ec_events e LEFT JOIN tha_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN tha_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN tha_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) WHERE e.post_id = 236 GROUP BY e.post_id 0.33 1
4 SELECT e.post_id, e.timezone_name, e.recurrence_rules, e.exception_rules, e.allday, 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.contact_url, e.cost, e.ticket_url, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.longitude, e.latitude, e.show_coordinates, GROUP_CONCAT( ttc.term_id ) AS categories, GROUP_CONCAT( ttt.term_id ) AS tags , e.start as start, e.end as end, e.allday FROM tha_ai1ec_events e LEFT JOIN tha_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN tha_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN tha_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) WHERE e.post_id = 236 GROUP BY e.post_id 0.37 1
5 SELECT e.post_id, e.timezone_name, e.recurrence_rules, e.exception_rules, e.allday, 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.contact_url, e.cost, e.ticket_url, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.longitude, e.latitude, e.show_coordinates, GROUP_CONCAT( ttc.term_id ) AS categories, GROUP_CONCAT( ttt.term_id ) AS tags , e.start as start, e.end as end, e.allday FROM tha_ai1ec_events e LEFT JOIN tha_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN tha_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN tha_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) WHERE e.post_id = 236 GROUP BY e.post_id 0.42 1
6 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 tha_ai1ec_events e INNER JOIN tha_posts p ON e.post_id = p.ID INNER JOIN tha_ai1ec_event_instances i ON e.post_id = i.post_id WHERE post_type = 'ai1ec_event' AND i.end >= 1432463360 AND post_status = 'publish' ORDER BY i.start ASC, post_title ASC LIMIT 0, 6 1.22 6
Total time, ms: 9.83