Hello there. Your K2 component is AWESOME and very easy to work with! Much kudos on a great product. We have found recently that our site (hosted at Siteground) goes down a few times a day. It's never more than a few minutes and when it does it displays a 503 error Service Temporarily Unavailable. We dug into it further and it looks like the K2 queries could be causing the issue. Any insight into this that the community could provide would be greatly appreciated.

Thanks in advance - Michael

Here is what we gathered from our logs:

=== TOP 5 of 5 (total) Slow Queries for the past 24 hours ==========
1. Executed 5h 34m 49s ago for 183.62907 sec on Database
Date: 2016-12-29 03:39:36 Query_time: 183.629070 Rows_examined: 69670: Rows_sent 1 Lock_time: 0.000141
# Schema: blabber9_joom1 Last_errno: 1160 Killed: 0 SELECT * FROM stg_jos_k2_items WHERE id > 70205 AND catid=38 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2016-12-29 08:36:26' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2016-12-29 08:36:26' ) AND access IN(1,1) AND trash=0 ORDER BY ordering ASC LIMIT 0, 1;

---

2. Executed 9h 3m 3s ago for 173.450275 sec on Database
Date: 2016-12-29 00:11:22 Query_time: 173.450275 Rows_examined: 1: Rows_sent 0 Lock_time: 164.753225
# Schema: blabber9_joom1 Last_errno: 1160 Killed: 0 UPDATE stg_jos_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '70556';

---

3. Executed 5h 35m 1s ago for 172.307486 sec on Database
Date: 2016-12-29 03:39:24 Query_time: 172.307486 Rows_examined: 66558: Rows_sent 1 Lock_time: 0.000134
# Schema: blabber9_joom1 Last_errno: 1160 Killed: 0 SELECT * FROM stg_jos_k2_items WHERE id > 67009 AND catid=46 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2016-12-29 08:36:26' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2016-12-29 08:36:26' ) AND access IN(1,1) AND trash=0 ORDER BY ordering ASC LIMIT 0, 1;

---

4. Executed 5h 34m 41s ago for 169.485263 sec on Database
Date: 2016-12-29 03:39:44 Query_time: 169.485263 Rows_examined: 50606: Rows_sent 1 Lock_time: 0.000145
# Schema: blabber9_joom1 Last_errno: 1160 Killed: 0 SELECT * FROM stg_jos_k2_items WHERE id < 20082 AND catid=39 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2016-12-29 08:36:28' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2016-12-29 08:36:28' ) AND access IN(1,1) AND trash=0 ORDER BY ordering DESC LIMIT 0, 1;

---

5. Executed 5h 34m 48s ago for 167.146801 sec on Database
Date: 2016-12-29 03:39:37 Query_time: 167.146801 Rows_examined: 70121: Rows_sent 1 Lock_time: 0.000097
# Schema: blabber9_joom1 Last_errno: 1160 Killed: 0 SELECT id FROM stg_jos_k2_items WHERE (`title` = '\'20th Century Women\' Review: Annette Bening Shines in Brilliant Mother-Son Drama' OR `alias`='20th-century-women-review-annette-bening-shines-in-brilliant-mother-son-drama');

---