Event Calendar Slow Loading. We have tried everything to speed it up.

  • Post date

Home › Forums › Calendar Products › Events Calendar PRO › Event Calendar Slow Loading. We have tried everything to speed it up.

Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • April 5, 2018 at 1:40 pm #1497953
    Cory Fechner
    Participant

    We have updated to php7, trimmed down our recurring events, we are cacheing as much as we can cache, we are hosting by WP Engine and have worked with them to try to speed things up, we have turned off the WP heartbeat jquery and are making sure to have our calendar team optimize photos as well as we are using SMUCK image plugin and we are using CloudFlare.

    We have roughly 11,000 events published. – many are expired but we get page visit from old events so we do not want to completely delete past events.
    4,574 event are recurring.

    Still the server reposince and page loads are so slow, any help would be appreciated.

    https://www.perfectduluthday.com/duluth-blog/duluth-music/

    https://www.perfectduluthday.com/duluth-blog/

    • This topic was modified 8 years ago by Cory Fechner. Reason: update
    April 6, 2018 at 11:17 am #1498979
    Cory Fechner
    Participant

    Here are the correct URLs to calendar pages.

    https://www.perfectduluthday.com/duluth-events/

    https://www.perfectduluthday.com/duluth-events/category/music/

    April 9, 2018 at 6:33 am #1500455
    Jaime Marchwinski
    Keymaster

    Hi Cory,

    Thanks so much for reaching out!

    As a first step, can you update all of your Events Calendar related plugins to their most recent versions and see if that helps to speed things up on your site.

    Also, please have a look at our Performance Considerations and see if there is anything you can adjust in order to help your site run better:

    https://theeventscalendar.com/knowledgebase/performance-considerations/

    After that, you may be interested in caching, so take a look at this article:  https://theeventscalendar.com/knowledgebase/caching-basics/

    In addition, you can check out some of the solutions provided in this forum post:

    https://theeventscalendar.com/support/forums/topic/decreasing-loading-time-for-big-amount-of-events/

    I would also recommend looking into some of the plugins in this blog post, as they may be able to help you pinpoint where site slowness may be occurring:

    https://theeventscalendar.com/favorite-developer-plugins/

    Let me know how it goes and if you need any further assistance on this topic!

     

    Thanks,

    Jaime

    April 9, 2018 at 7:27 am #1500532
    Cory Fechner
    Participant

    Why would these queries be so sl

    ow.

    April 10, 2018 at 6:36 am #1502824
    Jaime Marchwinski
    Keymaster

    Hi Cory,

    There could be many reasons why the queries are running slowly.  If you can provide me with some more specific information, I may be able to provide you with some better advice.

    In the meantime, have you been able to take a look at the links and performance considerations that I provided you with?

    Let me know how that goes!

     

    Thanks,

    Jaime

    April 11, 2018 at 4:47 pm #1504949
    Cory Fechner
    Participant

    Jaime,

    Does this help – you can see some queries that are sucking up time!

    Cory

    Query Monitor
    Overview
    Page generation timePeak memory usageDatabase query timeDatabase queriesObject
    cache
    11.7329
    0.3% of 3,600s limit 20,871 kB
    4.0% of 524,288 kB limit 7.4140 SELECT
    https://www.perfectduluthday.com/duluth-events/#: 201
    SHOW https://www.perfectduluthday.com/duluth-events/#: 3
    UPDATE https://www.perfectduluthday.com/duluth-events/#: 3
    INSERT https://www.perfectduluthday.com/duluth-events/#: 4
    Total: 211 96.1% hit rate (21,065 hits, 861 misses)
    External object cache not in use
    Database Errors
    QueryCall StackComponentError CodeError Message
    INSERT INTO `wp_adrotate_stats` (`ad`, `group`, `thetime`, `clicks`,
    `impressions`)
    VALUES (NULL, ‘2’, ‘1523404800’, ‘0’, ‘1’) /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/adrotate/adrotate-functions.php:168]
    */

    1. Unknown

    Unknown qmdb Column ‘ad’ cannot be null
    INSERT INTO `wp_adrotate_tracker` (`ipaddress`, `timer`, `bannerid`,
    `stat`, `useragent`, `country`, `city`)
    VALUES (‘199.119.210.79’, ‘1523472005’, NULL, ‘i’, ”, ”, ”) /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/adrotate/adrotate-functions.php:171]
    */

    1. Unknown

    Unknown qmdb Column ‘bannerid’ cannot be null
    Slow Database Queries (above 0.05s)
    QueryCallerTime
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, 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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’ )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    AND (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    OR (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    AND tribe_event_end_date.meta_value = ‘2018-04-11 18:39:00’ ))
    ORDER BY EventStartDate ASC, wp_posts.post_date ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 20 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/index.php:17] */

    +
    1. WP_Query-get_posts

    1.5749
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, 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 )
    INNER JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’
    AND mt1.meta_key = ‘_EventStartDate’ )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    AND (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    OR (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    AND tribe_event_end_date.meta_value = ‘2018-04-11 18:39:00′ ))
    ORDER BY EventStartDate ASC, wp_posts.post_date ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 20 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/schema/includes/json/post-type-archive.php:70]
    */

    +
    1. WP_Query-get_posts

    2.6887
    SELECT DISTINCT m.meta_value
    FROM wp_postmeta m
    INNER JOIN wp_posts p
    ON p.ID=m.post_id
    WHERE p.post_type=’tribe_events’
    AND p.post_status=’publish’
    AND m.meta_key=’_EventVenueID’
    AND m.meta_value 0 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar-filterbar/src/Tribe/Filters/Venue.php:20]
    */

    +
    1. Tribe__Events__Filterbar__Filters__Venue-get_values

    0.1832
    SELECT DISTINCT meta_value
    FROM wp_postmeta
    WHERE meta_key = ‘_EventCost’
    AND LENGTH( meta_value ) 0; /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Cost_Utils.php:37]
    */

    +
    1. Tribe__Events__Cost_Utils-get_all_costs

    0.1304
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, 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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’ )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    AND tribe_event_end_date.meta_value ‘2018-04-11 18:40:02’
    ORDER BY EventStartDate ASC, wp_posts.post_date ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1073]
    */

    +
    1. WP_Query-get_posts

    1.2749
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, 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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’ )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    AND tribe_event_end_date.meta_value ‘2018-04-11 18:40:04’
    ORDER BY EventStartDate ASC, wp_posts.post_date ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1073]
    */

    +
    1. WP_Query-get_posts

    1.2393
    $wpdb Queries
    Extended query information such as the component and affected rows is not
    available. Query Monitor was unable to symlink its db.php file into place. See
    this wiki page for more information.
    https://github.com/johnbillion/query-monitor/wiki/db.php-Symlink
    AscendingDescendingQueryAllNon-SELECTINSERTSELECTSHOWUPDATECallerAll
    _prime_post_cachesadrotate_count_impressionadrotate_custom_javascript
    adrotate_filter_scheduleadrotate_groupadrotate_statsget_objects_in_term
    get_optionTribe__Events__Cost_Utils-get_all_costs
    Tribe__Events__Filterbar__Filters__Venue-get_values
    Tribe__Events__Pro__Recurrence__Meta::get_start_dates
    Tribe__Events__Query::getHideFromUpcomingEventsupdate_meta_cache
    update_optionWP_Post::get_instanceWP_Query-get_posts
    WP_Query-set_found_postswp_rp_head_resourceswp_rp_should_exclude
    WP_Term::get_instanceWP_Term_Query-get_termsWP_User::get_data_by
    WPFront_Entity_Base-get_byWPSR_redirectTimeAscendingDescending
    1 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘arve_options_main’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/advanced-responsive-video-embedder/includes/class-arve-shared.php:67]
    */

    +
    1. get_option

    0.0004
    2 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘arve_options_shortcodes’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/advanced-responsive-video-embedder/includes/class-arve-shared.php:68]
    */

    +
    1. get_option

    0.0002
    3 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘arve_options_params’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/advanced-responsive-video-embedder/includes/class-arve-shared.php:69]
    */

    +
    1. get_option

    0.0001
    4 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘iframely_api_key’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/iframely/iframely.php:240]
    */

    +
    1. get_option

    0.0003
    5 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘iframely_api_params’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/iframely/iframely.php:248]
    */

    +
    1. get_option

    0.0001
    6 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘active_sitewide_plugins’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/invisible-recaptcha/includes/modules/MchModulesController.php:64]
    */

    +
    1. get_option

    0.0002
    7 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘responsive_lightbox_version’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/responsive-lightbox/responsive-lightbox.php:188]
    */

    +
    1. get_option

    0.0002
    8 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘responsive_lightbox_settings’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/responsive-lightbox/responsive-lightbox.php:206]
    */

    +
    1. get_option

    0.0001
    9 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘responsive_lightbox_configuration’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/responsive-lightbox/responsive-lightbox.php:209]
    */

    +
    1. get_option

    0.0001
    10 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘iworks_rate’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/upprev/vendor/iworks/rate/rate.php:89]
    */

    +
    1. get_option

    0.0002
    11 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘wp-smush-last_settings’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/wp-smush-pro/lib/class-wp-smush-settings.php:227]
    */

    +
    1. get_option

    0.0003
    12 SELECT *
    FROM wp_wpfront_ure_options
    WHERE option_name = ‘wp_wpfront_ure_options-db-version’ /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/wpfront-user-role-editor/classes/base/class-wpfront-entity-base.php:243]
    */

    +
    1. WPFront_Entity_Base-get_by

    0.0003
    13 SELECT *
    FROM wp_wpfront_ure_options
    WHERE option_name = ‘disable_navigation_menu_permissions’ /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/wpfront-user-role-editor/classes/base/class-wpfront-entity-base.php:243]
    */

    +
    1. WPFront_Entity_Base-get_by

    0.0001
    14 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘wpmudev_apikey’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/wpmudev-updates/includes/class-wpmudev-dashboard-api.php:66]
    */

    +
    1. get_option

    0.0001
    15 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘ic-woocommerce-settings’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/invisible-recaptcha/includes/modules/MchBaseModule.php:74]
    */

    +
    1. get_option

    0.0001
    16 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘ic-buddypress-settings’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/invisible-recaptcha/includes/modules/MchBaseModule.php:74]
    */

    +
    1. get_option

    0.0001
    17 SELECT *
    FROM wp_users
    WHERE user_login = ‘Cory’ /* From [www.perfectduluthday.com/duluth-events/]
    in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/common/src/Tribe/Main.php:249]
    */

    +
    1. WP_User::get_data_by

    0.0005
    18 SELECT user_id, meta_key, meta_value
    FROM wp_usermeta
    WHERE user_id IN (18)
    ORDER BY umeta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/common/src/Tribe/Main.php:249]
    */

    +
    1. update_meta_cache

    0.0005
    19 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘iframely_only_shortcode’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/iframely/iframely.php:40]
    */

    +
    1. get_option

    0.0004
    20 SHOW FULL COLUMNS
    FROM `wp_options` /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/functions.php:1064]
    */

    +
    1. update_option

    0.0005
    21 UPDATE `wp_options`
    SET `option_value` = ‘1’
    WHERE `option_name` = ‘posts_per_page’ /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/functions.php:1064]
    */

    +
    1. update_option

    0.0028
    22 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘ure_role_additional_options_values’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/user-role-editor/includes/classes/role-additional-options.php:44]
    */

    +
    1. get_option

    0.0004
    23 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘wpengine_news_feed_enabled’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-settings.php:450] */

    +
    1. get_option

    0.0002
    24 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘wdp_un_limit_to_user’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/wpmudev-updates/includes/class-wpmudev-dashboard-site.php:1021]
    */

    +
    1. get_option

    0.0002
    25 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘tribe_events_import_column_mapping_organizers’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Aggregator/Page.php:75]
    */

    +
    1. get_option

    0.0003
    26 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘tribe_events_import_column_mapping_venues’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Aggregator/Page.php:76]
    */

    +
    1. get_option

    0.0001
    27 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘_transient_timeout_eventrocket_plugin_alert’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/event-rocket/misc/404-helper.php:42]
    */

    +
    1. get_option

    0.0003
    28 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘_transient_eventrocket_plugin_alert’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/event-rocket/misc/404-helper.php:42]
    */

    +
    1. get_option

    0.0001
    29 SELECT wp_postmeta.post_id
    FROM wp_postmeta
    WHERE wp_postmeta.meta_key = ‘_EventHideFromUpcoming’
    AND wp_postmeta.meta_value = ‘yes’ /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:881]
    */

    +
    1. Tribe__Events__Query::getHideFromUpcomingEvents

    0.0004
    30 SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, 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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’ )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    AND (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    OR (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    AND tribe_event_end_date.meta_value = ‘2018-04-11 18:39:00’ ))
    ORDER BY EventStartDate ASC, wp_posts.post_date ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 20 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/index.php:17] */

    +
    1. WP_Query-get_posts

    1.5749
    31 SELECT FOUND_ROWS() /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/index.php:17] */

    +
    1. WP_Query-set_found_posts

    0.0002
    32 SELECT t.*, tt.*, tr.object_id
    FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt
    ON t.term_id = tt.term_id
    INNER JOIN wp_term_relationships AS tr
    ON tr.term_taxonomy_id = tt.term_taxonomy_id
    WHERE tt.taxonomy IN (‘post_tag’, ‘event tag’, ‘tribe_events_cat’)
    AND tr.object_id IN (158273, 177279, 169859, 129338, 164998, 171092,
    178536, 133574, 177492, 127496, 171947, 165062, 135990, 171948, 176146,
    176657, 178234, 176974, 133152, 132408)
    ORDER BY t.name ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/index.php:17] */

    +
    1. WP_Term_Query-get_terms

    0.0013
    33 SELECT post_id, meta_key, meta_value
    FROM wp_postmeta
    WHERE post_id IN
    (158273,177279,169859,129338,164998,171092,178536,133574,177492,127496,171947,165062,135990,171948,176146,176657,178234,176974,133152,132408)
    ORDER BY meta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/index.php:17] */

    +
    1. update_meta_cache

    0.0029
    34 select * from wp_WP_SEO_Redirection where enabled=1 and regex=” and
    (redirect_from=’/duluth-events/’ or redirect_from=’/duluth-events’ ) /*
    From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/seo-redirection/seo-redirection.php:489]
    */

    +
    1. WPSR_redirect

    0.0004
    35 select * from wp_WP_SEO_Redirection where enabled=1 and regex” and
    (‘/duluth-events/’ regexp regex or ‘/duluth-events’ regexp regex ) order by
    LENGTH(regex) desc /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/seo-redirection/seo-redirection.php:495]
    */

    +
    1. WPSR_redirect

    0.0002
    36 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘_tribe_chunker_chunked_keys’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/common/src/Tribe/Meta/Chunker.php:120]
    */

    +
    1. get_option

    0.0002
    37 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘_transient_timeout_tribe-community-events-page-id’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar-community-events/src/Tribe/Main.php:2968]
    */

    +
    1. get_option

    0.0002
    38 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘_transient_tribe-community-events-page-id’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar-community-events/src/Tribe/Main.php:2968]
    */

    +
    1. get_option

    0.0001
    39 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘_transient_timeout_geoloc_center_point_estimation’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/events-calendar-pro/src/Tribe/Geo_Loc.php:876]
    */

    +
    1. get_option

    0.0003
    40 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘_transient_geoloc_center_point_estimation’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/events-calendar-pro/src/Tribe/Geo_Loc.php:876]
    */

    +
    1. get_option

    0.0001
    41 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘tribe_customizer’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/common/src/Tribe/Customizer.php:264]
    */

    +
    1. get_option

    0.0003
    42 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘tribe_events_pro_customizer’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/common/src/Tribe/Customizer.php:142]
    */

    +
    1. get_option

    0.0001
    43 SELECT *
    FROM wp_users
    WHERE ID = ‘9118’ /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/wordpress-seo/frontend/class-opengraph.php:51]
    */

    +
    1. WP_User::get_data_by

    0.0003
    44 SELECT user_id, meta_key, meta_value
    FROM wp_usermeta
    WHERE user_id IN (9118)
    ORDER BY umeta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/wordpress-seo/frontend/class-opengraph.php:51]
    */

    +
    1. update_meta_cache

    0.0003
    45 SELECT option_value
    FROM wp_options
    WHERE option_name = ‘can_compress_scripts’
    LIMIT 1 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header.php:49] */

    +
    1. get_option

    0.0004
    46 SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, 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 )
    INNER JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’
    AND mt1.meta_key = ‘_EventStartDate’ )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    AND (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    OR (wp_postmeta.meta_value = ‘2018-04-11 18:39:00’
    AND tribe_event_end_date.meta_value = ‘2018-04-11 18:39:00’ ))
    ORDER BY EventStartDate ASC, wp_posts.post_date ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 20 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/schema/includes/json/post-type-archive.php:70]
    */

    +
    1. WP_Query-get_posts

    2.6887
    47 SELECT FOUND_ROWS() /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/schema/includes/json/post-type-archive.php:70]
    */

    +
    1. WP_Query-set_found_posts

    0.0002
    48 SELECT COUNT(tt.term_id)
    FROM wp_term_taxonomy tt, wp_term_relationships tr
    WHERE tt.taxonomy = ‘category’
    AND tt.term_taxonomy_id = tr.term_taxonomy_id
    AND tr.object_id = 158273
    AND tt.term_id IN (275) /* From [www.perfectduluthday.com/duluth-events/]
    in
    [/nas/content/live/perfectduluth/wp-content/plugins/wordpress-23-related-posts-plugin/init.php:409]
    */

    +
    1. wp_rp_should_exclude

    0.0005
    49 SELECT DISTINCT(label)
    FROM wp_wp_rp_tags
    WHERE post_id=158273
    ORDER BY weight desc; /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/wordpress-23-related-posts-plugin/init.php:438]
    */

    +
    1. wp_rp_head_resources

    0.0004
    50 SELECT `id`, `adspeed`
    FROM `wp_adrotate_groups`
    WHERE `name` != ”
    AND `modus` = 1
    ORDER BY `id` ASC; /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/plugins/adrotate/adrotate-output.php:528]
    */

    +
    1. adrotate_custom_javascript

    0.0003
    51 SELECT t.*, tt.*
    FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt
    ON t.term_id = tt.term_id
    WHERE t.term_id = 6866 /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. WP_Term::get_instance

    0.0005
    52 SELECT tr.object_id
    FROM wp_term_relationships AS tr
    INNER JOIN wp_term_taxonomy AS tt
    ON tr.term_taxonomy_id = tt.term_taxonomy_id
    WHERE tt.taxonomy IN (‘nav_menu’)
    AND tt.term_id IN (‘6866’)
    ORDER BY tr.object_id ASC /* From [www.perfectduluthday.com/duluth-events/]
    in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. get_objects_in_term

    0.0005
    53 SELECT wp_posts.*
    FROM wp_posts
    WHERE 1=1
    AND wp_posts.ID IN
    (1,2,3,4,5,80882,80883,80884,80920,80921,94290,94291,94292,94293,94294,94296,94297,94298,94305,94416,94417,94420,94421,94425,94428,94429,94432,94433,94434,94436,94437,94438,94440,94441,95219,101786,125114,146121,146122,146123,146124,146125,146126,146127,146128,146129,146130,146131,146133,146135,146138,146139,148779,148780,148782,148783,148785,148788,148789,148790,148792,148793,172854,172856,172857,172858,172859,172860,172864,172865)
    AND wp_posts.post_type = ‘nav_menu_item’
    AND ((wp_posts.post_status = ‘publish’))
    ORDER BY wp_posts.menu_order ASC /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. WP_Query-get_posts

    0.0017
    54 SELECT post_id, meta_key, meta_value
    FROM wp_postmeta
    WHERE post_id IN
    (94290,80920,94291,94416,94417,94420,94421,94425,94428,94429,94432,94433,94434,94436,94437,94438,94440,94441,94293,94292,94294,80882,80921,146138,146139,146121,146122,146123,146124,146125,146126,146127,146128,146129,146130,146131,146133,146135,172857,172860,172856,172859,172865,172858,172864,148779,148780,148792,148782,148783,148785,148788,148790,148793,148789,125114,80883,94296,80884,94297,94298,94305,95219,172854,101786)
    ORDER BY meta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. update_meta_cache

    0.0048
    55 SELECT wp_posts.*
    FROM wp_posts
    WHERE 1=1
    AND wp_posts.ID IN
    (76351,7633,28966,7636,7630,7639,14415,62,7639,14656,64647,517,105742)
    AND wp_posts.post_type = ‘page’
    AND ((wp_posts.post_status = ‘publish’))
    ORDER BY wp_posts.post_date DESC /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. WP_Query-get_posts

    0.0010
    56 SELECT post_id, meta_key, meta_value
    FROM wp_postmeta
    WHERE post_id IN
    (105742,76351,64647,28966,14656,14415,7639,7636,7633,7630,517,62)
    ORDER BY meta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. update_meta_cache

    0.0025
    57 SELECT wp_posts.*
    FROM wp_posts
    WHERE 1=1
    AND wp_posts.ID IN (130169,145940,139889,126143,141425,164488)
    AND wp_posts.post_type = ‘tribe_organizer’
    AND ((wp_posts.post_status = ‘publish’))
    ORDER BY wp_posts.post_date DESC /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. WP_Query-get_posts

    0.0007
    58 SELECT post_id, meta_key, meta_value
    FROM wp_postmeta
    WHERE post_id IN (164488,145940,141425,139889,130169,126143)
    ORDER BY meta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. update_meta_cache

    0.0009
    59 SELECT wp_posts.*
    FROM wp_posts
    WHERE 1=1
    AND wp_posts.ID IN
    (122241,122148,122151,122152,122205,122171,122397,122220,122164)
    AND wp_posts.post_type = ‘tribe_venue’
    AND ((wp_posts.post_status = ‘publish’))
    ORDER BY wp_posts.post_date DESC /* From [
    http://www.perfectduluthday.com/duluth-events/%5D in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. WP_Query-get_posts

    0.0007
    60 SELECT post_id, meta_key, meta_value
    FROM wp_postmeta
    WHERE post_id IN
    (122397,122241,122220,122205,122171,122164,122151,122152,122148)
    ORDER BY meta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. update_meta_cache

    0.0019
    61 SELECT t.*, tt.*
    FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt
    ON t.term_id = tt.term_id
    WHERE tt.taxonomy IN (‘category’)
    AND t.term_id IN ( 4,7,275,12,15,51,17,18,1480,202,19,20,138,21 )
    AND tt.count 0
    ORDER BY t.name ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. WP_Term_Query-get_terms

    0.0011
    62 SELECT term_id, meta_key, meta_value
    FROM wp_termmeta
    WHERE term_id IN (4,275,12,15,7,51,17,18,1480,202,19,20,138,21)
    ORDER BY meta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. update_meta_cache

    0.0003
    63 SELECT t.*, tt.*
    FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt
    ON t.term_id = tt.term_id
    WHERE tt.taxonomy IN (‘tribe_events_cat’)
    AND t.term_id IN (
    8310,8306,8299,8305,8312,8302,8304,8311,8308,8298,8314,8301,8309,8297 )
    AND tt.count 0
    ORDER BY t.name ASC /* From [www.perfectduluthday.com/duluth-events/] in
    [/nas/content/live/perfectduluth/wp-content/themes/feather/header-template-two.php:44]
    */

    +
    1. WP_Term_Query-get_terms

    0.0011
    64 SELECT term_id, meta_key, meta_value
    FROM wp_termmeta
    WHERE term_id IN
    (8310,8299,8305,8312,8302,8304,8311,8308,8298,8314,8301,8309,8297,8306)
    ORDER BY meta_id ASC /* From [www.perfectduluthday.com/duluth-events/] in

    April 11, 2018 at 4:51 pm #1504952
    Cory Fechner
    Participant

    Slow Database Queries (above 0.05s)
    QueryCallerTime
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate,
    tribe_event_end_date.meta_value as EventEndDate
    FROM wp_posts
    LEFT JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    LEFT JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.post_id )
    LEFT JOIN wp_postmeta AS mt2
    ON (wp_posts.ID = mt2.post_id
    AND mt2.meta_key = ‘_EventHideFromUpcoming’ )
    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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND wp_posts.ID NOT IN (158273)
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’
    AND ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) ‘2018-04-11 17:00:00’ )
    OR ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) = ‘2018-04-11 17:00:00’ )
    AND mt1.post_id 158273 ) )
    AND mt2.post_id IS NULL )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    ORDER BY EventStartDate DESC, wp_posts.ID DESC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate DESC
    LIMIT 0, 1 /* From [
    http://www.perfectduluthday.com/the-event/darin-bergsven-4/2018-04-11/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1073]
    */

    +
    1. WP_Query-get_posts

    4.3027
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate,
    tribe_event_end_date.meta_value as EventEndDate
    FROM wp_posts
    LEFT JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    LEFT JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.post_id )
    LEFT JOIN wp_postmeta AS mt2
    ON (wp_posts.ID = mt2.post_id
    AND mt2.meta_key = ‘_EventHideFromUpcoming’ )
    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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND wp_posts.ID NOT IN (158273)
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’
    AND ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) ‘2018-04-11 17:00:00’ )
    OR ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) = ‘2018-04-11 17:00:00’ )
    AND mt1.post_id 158273 ) )
    AND mt2.post_id IS NULL )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    ORDER BY EventStartDate ASC, wp_posts.ID ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 1 /* From [
    http://www.perfectduluthday.com/the-event/darin-bergsven-4/2018-04-11/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1073]
    */

    +
    1. WP_Query-get_posts

    3.2998
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate,
    tribe_event_end_date.meta_value as EventEndDate
    FROM wp_posts
    LEFT JOIN wp_term_relationships
    ON (wp_posts.ID = wp_term_relationships.object_id)
    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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND wp_posts.ID NOT IN (158273)
    AND ( wp_term_relationships.term_taxonomy_id IN (8321) )
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’ )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    AND (wp_postmeta.meta_value = ‘2018-04-11 18:50:00’
    OR (wp_postmeta.meta_value = ‘2018-04-11 18:50:00’
    AND tribe_event_end_date.meta_value = ‘2018-04-11 18:50:00’ ))
    ORDER BY 1 ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 3 /* From [
    http://www.perfectduluthday.com/the-event/darin-bergsven-4/2018-04-11/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1073]
    */

    +
    1. WP_Query-get_posts

    1.0255
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate,
    tribe_event_end_date.meta_value as EventEndDate
    FROM wp_posts
    LEFT JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    LEFT JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.post_id )
    LEFT JOIN wp_postmeta AS mt2
    ON (wp_posts.ID = mt2.post_id
    AND mt2.meta_key = ‘_EventHideFromUpcoming’ )
    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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND wp_posts.ID NOT IN (158273)
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’
    AND ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) ‘2018-04-11 17:00:00’ )
    OR ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) = ‘2018-04-11 17:00:00’ )
    AND mt1.post_id 158273 ) )
    AND mt2.post_id IS NULL )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    ORDER BY EventStartDate DESC, wp_posts.ID DESC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate DESC
    LIMIT 0, 1 /* From [
    http://www.perfectduluthday.com/the-event/darin-bergsven-4/2018-04-11/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1073]
    */

    +
    1. WP_Query-get_posts

    3.7259
    SELECT SQL_CALC_FOUND_ROWS *
    FROM (
    SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate,
    tribe_event_end_date.meta_value as EventEndDate
    FROM wp_posts
    LEFT JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    LEFT JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.post_id )
    LEFT JOIN wp_postmeta AS mt2
    ON (wp_posts.ID = mt2.post_id
    AND mt2.meta_key = ‘_EventHideFromUpcoming’ )
    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 = ‘_EventEndDate’ )
    WHERE 1=1
    AND wp_posts.ID NOT IN (158273)
    AND ( wp_postmeta.meta_key = ‘_EventStartDate’
    AND ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) ‘2018-04-11 17:00:00’ )
    OR ( ( mt1.meta_key = ‘_EventStartDate’
    AND CAST(mt1.meta_value AS DATETIME) = ‘2018-04-11 17:00:00’ )
    AND mt1.post_id 158273 ) )
    AND mt2.post_id IS NULL )
    AND wp_posts.post_type = ‘tribe_events’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘tribe-ea-success’
    OR wp_posts.post_status = ‘tribe-ea-failed’
    OR wp_posts.post_status = ‘tribe-ea-schedule’
    OR wp_posts.post_status = ‘tribe-ea-pending’
    OR wp_posts.post_status = ‘tribe-ea-draft’
    OR wp_posts.post_status = ‘private’)
    ORDER BY EventStartDate ASC, wp_posts.ID ASC ) a
    GROUP BY IF( post_parent = 0, ID, post_parent )
    ORDER BY EventStartDate ASC
    LIMIT 0, 1 /* From [
    http://www.perfectduluthday.com/the-event/darin-bergsven-4/2018-04-11/%5D in
    [/nas/content/live/perfectduluth/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1073]
    */

    +
    1. WP_Query-get_posts

    3.3016
    $wpdb Queries

    April 12, 2018 at 4:50 am #1505302
    Jaime Marchwinski
    Keymaster

    Hi Cory,

    Thanks for providing me with that information.

    First off, it’s worth mentioning that with events that have custom recurrence rules do tend to slow things down, more so that other events.

    It looks like an event on 4/11 may be causing some slowness, is there an event there that you can delete or change (since it has passed)?

    Do you have any caching (specifically object caching) set up on your site?

    I would also recommend updating your plugins to the latest versions, as performance considerations have been taken into account in newer versions.

    One more thing to look at is your settings for event cleanup.  What do you have set up for Clean up recurring events after under Events Settings < General?

    Let me know how all of that goes!

     

    Thanks,

    Jaime

     

     

    April 17, 2018 at 4:32 am #1508945
    Cory Fechner
    Participant

    Jamie,

    I found that the action tribe_list was called a large number of times –
    what can we do soften the ajax calls by tribe-list?

    24328 [action] = tribe_list
    2362 [action] = query-attachments
    1906 [action] = smush_get_attachment_details
    1870 [action] = wp-remove-post-lock
    1250 [action] = heartbeat
    950 [action] = tribe_event_day
    770 [action] = wpseo_filter_shortcodes
    634 [action] = tribe_calendar
    542 [action] = get-post-thumbnail-html
    534 [action] = get-attachment

    April 17, 2018 at 5:00 am #1508975
    Jaime Marchwinski
    Keymaster

    Hi Cory,

    You can try to dequeue some of our scripts using the following extension:

    https://theeventscalendar.com/extensions/dequeue-assets/

    Let me know if that helps!

     

    Thanks,

    Jaime

    May 9, 2018 at 9:35 am #1526292
    Support Droid
    Keymaster

    Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

    Thanks so much!
    The Events Calendar Support Team

  • Author
    Posts
Viewing 11 posts - 1 through 11 (of 11 total)
  • The topic ‘Event Calendar Slow Loading. We have tried everything to speed it up.’ is closed to new replies.