slow queries

Hi,

My hosting is telling me I have many slow sql queries happening. I notice a lot of reference to geodirectory in the log but it makes nil sense.

Any chance you guys know what this means and whether it has to do with any geodirectory plugin.

Thanks,
Lise

=== TOP 10 of 472 (total) Slow Queries for the past 24 hours ==========
1. Executed 7h 14m 48s ago for 57.52962 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:31:56 Query_time: 57.529620 Rows_examined: 0: Rows_sent 1 Lock_time: 0.000071
# Schema: guidemea_wp403 Last_errno: 1160 Killed: 0 SELECT COUNT(post_id) FROM x1e_geodir_gd_music_tuition_detail WHERE post_status = ‘publish’ AND post_locations LIKE ‘%,[australia]’ AND post_locations LIKE ‘%,[victoria],%’ AND post_locations LIKE ‘[mallacoota],%’ AND FIND_IN_SET(304, gd_music_tuitioncategory);
————————————————————————————————-
2. Executed 7h 14m 49s ago for 40.154017 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:31:55 Query_time: 40.154017 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000099
# Schema: guidemea_wp403 Last_errno: 0 Killed: 0 SELECT option_value FROM x1e_options WHERE option_name = ‘geodir_location_prefix’ LIMIT 1;
————————————————————————————————-
3. Executed 7h 14m 49s ago for 40.147944 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:31:55 Query_time: 40.147944 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000077
# Schema: guidemea_wp403 Last_errno: 1160 Killed: 0 SELECT option_value FROM x1e_options WHERE option_name = ‘mobmenu_opt_left_submenu_bg_color’ LIMIT 1;
————————————————————————————————-
4. Executed 7h 14m 49s ago for 38.692348 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:31:55 Query_time: 38.692348 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000085
# Schema: guidemea_wp403 Last_errno: 0 Killed: 0 SELECT option_value FROM x1e_options WHERE option_name = ‘geodir_location_prefix’ LIMIT 1;
————————————————————————————————-
5. Executed 7h 15m 2s ago for 33.016427 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:31:42 Query_time: 33.016427 Rows_examined: 1: Rows_sent 1 Lock_time: 0.050106
# Schema: guidemea_wp403 Last_errno: 0 Killed: 0 SELECT option_value FROM x1e_options WHERE option_name = ‘wp-smush-last_settings’ LIMIT 1;
————————————————————————————————-
6. Executed 7h 14m 47s ago for 32.290006 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:31:57 Query_time: 32.290006 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000101
# Schema: guidemea_wp403 Last_errno: 1160 Killed: 0 SELECT option_value FROM x1e_options WHERE option_name = ‘ngg_wizards’ LIMIT 1;
————————————————————————————————-
7. Executed 7h 14m 47s ago for 28.280556 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:31:57 Query_time: 28.280556 Rows_examined: 11956: Rows_sent 7255 Lock_time: 0.273722
# Schema: guidemea_wp403 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM x1e_options WHERE autoload = ‘yes’;
——————————————————————————————————–
8. Executed 7h 14m 58s ago for 20.569919 sec on Database –> Unknown (NOT FOUND / DELETED)
Date: 2018-03-10 06:31:46 Query_time: 20.569919 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000086
# Schema: guidemea_wp403 Last_errno: 0 Killed: 0 SELECT option_value FROM x1e_options WHERE option_name = ‘geodir_location_prefix’ LIMIT 1;
————————————————————————————————-
9. Executed 7h 16m 39s ago for 18.237557 sec on Database –> guidemea_wp403
Date: 2018-03-10 06:30:05 Query_time: 18.237557 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000128
# Schema: guidemea_wp403 Last_errno: 0 Killed: 0 SELECT option_value FROM x1e_options WHERE option_name = ‘geodir_add_listing_link_main_nav’ LIMIT 1;
————————————————————————————————-
10. Executed 7h 15m 4s ago for 17.361367 sec