{"id":101252,"date":"2014-02-05T21:05:17","date_gmt":"2014-02-06T05:05:17","guid":{"rendered":"https:\/\/tri.be\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/"},"modified":"2014-04-17T06:31:18","modified_gmt":"2014-04-17T13:31:18","slug":"this-query-takes-longer-than-10-minutes","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/","title":{"rendered":"This Query takes longer than 10 minutes"},"content":{"rendered":"<p>After setting up a MySQL slow log to find out why our database has been recently getting overloaded, the log showed this query taking longer than 10 minutes, and the log is full of them. Can someone explain to me what exactly this query is doing and what part of the plugin executes it?<\/p>\n<p>SELECT Max(lat) max_lat,<br \/>\n\t\t\t\t\t       Max(lng) max_lng,<br \/>\n\t\t\t\t\t       Min(lat) min_lat,<br \/>\n\t\t\t\t\t       Min(lng) min_lng<br \/>\n\t\t\t\t\tFROM   (SELECT post_id AS venue_id,<br \/>\n\t\t\t\t               CASE<br \/>\n\t\t\t\t                 WHEN meta_key = &#8216;_VenueLat&#8217; THEN meta_value<br \/>\n\t\t\t\t               end     AS LAT,<br \/>\n\t\t\t\t               CASE<br \/>\n\t\t\t\t                 WHEN meta_key = &#8216;_VenueLng&#8217; THEN meta_value<br \/>\n\t\t\t\t               end     AS LNG<br \/>\n\t\t\t\t        FROM   wp_postmeta<br \/>\n\t\t\t\t        WHERE  ( meta_key = &#8216;_VenueLat&#8217;<br \/>\n\t\t\t\t            OR meta_key = &#8216;_VenueLng&#8217;)<br \/>\n\t\t\t\t            AND post_id IN (SELECT meta_value FROM wp_postmeta WHERE meta_key=&#8217;_EventVenueID&#8217;)<br \/>\n\t\t\t\t            ) coors;<\/p>\n","protected":false},"template":"","class_list":["post-101252","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>This Query takes longer than 10 minutes -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"This Query takes longer than 10 minutes -\" \/>\n<meta property=\"og:description\" content=\"After setting up a MySQL slow log to find out why our database has been recently getting overloaded, the log showed this query taking longer than 10 minutes, and the log is full of them. Can someone explain to me what exactly this query is doing and what part of the plugin executes it? SELECT [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/\" \/>\n<meta property=\"article:modified_time\" content=\"2014-04-17T13:31:18+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/\",\"name\":\"This Query takes longer than 10 minutes -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2014-02-06T05:05:17+00:00\",\"dateModified\":\"2014-04-17T13:31:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"This Query takes longer than 10 minutes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"This Query takes longer than 10 minutes -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/","og_locale":"en_US","og_type":"article","og_title":"This Query takes longer than 10 minutes -","og_description":"After setting up a MySQL slow log to find out why our database has been recently getting overloaded, the log showed this query taking longer than 10 minutes, and the log is full of them. Can someone explain to me what exactly this query is doing and what part of the plugin executes it? SELECT [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/","article_modified_time":"2014-04-17T13:31:18+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/","name":"This Query takes longer than 10 minutes -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2014-02-06T05:05:17+00:00","dateModified":"2014-04-17T13:31:18+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/this-query-takes-longer-than-10-minutes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"This Query takes longer than 10 minutes"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/101252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/101252\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=101252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}