WCWS Champ. Series Game 1: #2 Oklahoma vs. #1 Texas (2024-06-05)

Calendar

When:

June 5, 2024 @ 7:45 pm America/New York Timezone

2024-06-05T19:45:00-04:00

2024-06-05T20:00:00-04:00

College Softball

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 wp_ai1ec_events e LEFT JOIN wp_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN wp_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN wp_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) LEFT JOIN wp_ai1ec_event_instances aei ON aei.id = 4384 AND e.post_id = aei.post_id WHERE e.post_id = 52935 GROUP BY e.post_id	0.31	1
2	SELECT `term_id`, `term_image`, `term_color` FROM `wp_ai1ec_event_category_meta`	0.07	21
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 , 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 wp_ai1ec_events e LEFT JOIN wp_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN wp_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN wp_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) LEFT JOIN wp_ai1ec_event_instances aei ON aei.id = 4384 AND e.post_id = aei.post_id WHERE e.post_id = 52935 GROUP BY e.post_id	0.09	1
Total time, ms: 0.47

Query

Duration, ms

Row Count

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 wp_ai1ec_events e LEFT JOIN wp_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN wp_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN wp_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) LEFT JOIN wp_ai1ec_event_instances aei ON aei.id = 4384 AND e.post_id = aei.post_id WHERE e.post_id = 52935 GROUP BY e.post_id

0.31

SELECT `term_id`, `term_image`, `term_color` FROM `wp_ai1ec_event_category_meta`

0.07

0.09

Total time, ms: 0.47

Search WJPA

WCWS Champ. Series Game 1: #2 Oklahoma vs. #1 Texas