I have a magento store on version 1.8.1.0 hosted with siteground. I've been notified by their system administrator that my database queries are hogging up too much resoruces. Here are what they've sent me. I'm at a complete loss in how to tackle this issue, any pointer would be greatly appreciated. 

1 Executed 9h 26m 48s ago for 16.454657 sec on Database --> DB\_production 
Date: 2015-10-05 22:41:18 Query\_time: 16.454657 Rows\_examined: 349107: Rows\_sent 1 Lock\_time: 0.000301

```
SELECT count(DISTINCT e.entity_id) 
FROM report_event AS report_table_views 
  INNER JOIN catalog_product_entity AS e ON e.entity_id = report_table_views.object_id AND e.entity_type_id = 4 
  INNER JOIN catalog_product_entity_int AS at_visibility_default ON (at_visibility_default.entity_id = e.entity_id) AND (at_visibility_default.attribute_id = '102') AND at_visibility_default.store_id = 0 
  LEFT JOIN catalog_product_entity_int AS at_visibility ON (at_visibility.entity_id = e.entity_id) AND (at_visibility.attribute_id = '102') AND (at_visibility.store_id = 4) 
  INNER JOIN catalog_product_entity_int AS at_status_default ON (at_status_default.entity_id = e.entity_id) AND (at_status_default.attribute_id = '96') AND at_status_default.store_id = 0 
  LEFT JOIN catalog_product_entity_int AS at_status ON (at_status.entity_id = e.entity_id) AND (at_status.attribute_id = '96') AND (at_status.store_id = 4) 
WHERE (report_table_views.event_type_id = 1) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1);

```

2 Executed 9h 26m 48s ago for 16.381442 sec on Database --> DB\_production 
Date: 2015-10-05 22:41:18 Query\_time: 16.381442 Rows\_examined: 349107: Rows\_sent 1 Lock\_time: 0.000517 

```
SELECT count(DISTINCT e.entity_id) 
FROM report_event AS report_table_views 
  INNER JOIN catalog_product_entity AS e ON e.entity_id = report_table_views.object_id AND e.entity_type_id = 4 
  INNER JOIN catalog_product_entity_int AS at_visibility_default ON (at_visibility_default.entity_id = e.entity_id) AND (at_visibility_default.attribute_id = '102') AND at_visibility_default.store_id = 0 
  LEFT JOIN catalog_product_entity_int AS at_visibility ON (at_visibility.entity_id = e.entity_id) AND (at_visibility.attribute_id = '102') AND (at_visibility.store_id = 4) 
  INNER JOIN catalog_product_entity_int AS at_status_default ON (at_status_default.entity_id = e.entity_id) AND (at_status_default.attribute_id = '96') AND at_status_default.store_id = 0 
  LEFT JOIN catalog_product_entity_int AS at_status ON (at_status.entity_id = e.entity_id) AND (at_status.attribute_id = '96') AND (at_status.store_id = 4) 
WHERE (report_table_views.event_type_id = 1) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1);

```

=== TOP 10 of 1854 (total) Slow Queries for the past 24 hours ==========
[36;1m 1. Executed 13h 30m 41s ago for 9.566494 sec on Database --> [33;1mDB\_production[0m [0m
[36mDate: 2015-10-06 21:35:51 Query\_time: 9.566494 Rows\_examined: 234795: Rows\_sent 68398 Lock\_time: 0.011157[0m

SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t\_s.value\_id IS NULL, t\_d.value, t\_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t\_s.attribute\_id = t\_d.attribute\_id AND t\_s.entity\_id = t\_d.entity\_id AND t\_s.store\_id = 4 WHERE (t\_d.entity\_type\_id = 4) AND (t\_d.entity\_id IN (1678, 1682, 1828, 1830, 1834, 1837, 1839, 1926, 1942, 1982, 1983, 1985, 1987, 1989, 2316, 2325, 3299, 1510, 2055, 2172, 2282, 2283, 2328, 2333, 1075, 1771, 1780, 1818, 1849, 1850, 1853, 2569, 2570, 2572, 2573, 2574, 2575, 2576, 2577, 2578, 2579, 2728)) AND (t\_d.attribute\_id IN ('75', '76', '120')) AND (t\_d.store\_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t\_s.value\_id IS NULL, t\_d.value, t\_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t\_s.attribute\_id = t\_d.attribute\_id AND t\_s.entity\_id = t\_d.entity\_id AND t\_s.store\_id = 4 WHERE (t\_d.entity\_type\_id = 4) AND (t\_d.entity\_id IN (1678, 1682, 1828, 1830, 1834, 1837, 1839, 1926, 1942, 1982, 1983, 1985, 1987, 1989, 2316, 2325, 3299, 1510, 2055, 2172, 2282, 2283, 2328, 2333, 1075, 1771, 1780, 1818, 1849, 1850, 1853,

====== I Truncated a lot of the entity ID for this post=======

3456, 3457, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3465, 3466, 3467, 3468, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2558, 2559, 2560, 2561, 2562, 2563, 2564, 2565, 2566, 2567, 2568, 2569, 2570, 2572, 2573, 2574, 2575, 2576, 2577, 2578, 2579, 2728)) AND (t\_d.attribute\_id IN ('96', '122', '124', '126', '127', '128', '129', '132', '134')) AND (t\_d.store\_id = 0);