MySQL тяжелые запросы

Хостер начал слать сообщения , мол , оптимизируйте скрипты для снижения нагрузки на сервер. Отключил уже все, что только можно, старые статьи пытаюсь периодически подчищать. Кэш включен ан 15 минут, сессии по 10 минут, обработчик отсутствует. Собственно сам сайт и пример тяжелых SQL запросов ( прислал хостер )

Код (sql):

1. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM mboxpro_content AS a INNER JOIN mboxpro_content_frontpage AS f ON f.content_id = a.id LEFT JOIN mboxpro_categories AS cc ON cc.id = a.catid LEFT JOIN mboxpro_sections AS s ON s.id = a.sectionid LEFT JOI...

Подскажите, что делать?

 

Судя из названия файла MySQL_Slow_Queries это и есть медленные запросы. Вот собственно файл, присланный хостером. Еще там есть файл smime.p7s , сюда не подгружается

--- добавлено: 31.10.2014, первое сообщение размещено: 31.10.2014 ---

Еще добавлю что из компонентов установлено xmap и JHC optimize . Кстати еще, во время чистки кеша page и plg_jhc_optimize создают достаточно тяжелые файлы ( первый около 900, второй около 300 )

--- добавлено: 31.10.2014 ---

Информация при отладке

Спойлер: Лог отладки

ИНФОРМАЦИЯ
Application afterLoad: 0.000 seconds, 0.23 MB
Application afterInitialise: 3.030 seconds, 3.91 MB
Application afterRoute: 3.034 seconds, 4.26 MB
Application afterDispatch: 5.160 seconds, 6.15 MB
Application afterRender: 5.197 seconds, 6.69 MB
ИСПОЛЬЗОВАНИЕ ПАМЯТИ
7105184
ЗАРЕГИСТРИРОВАНО ЗАПРОСОВ - 11

1. DELETE
   FROM mboxpro_session
   WHERE ( time < '1414755498' )
2. SELECT *
   FROM mboxpro_session
   WHERE session_id = '489c59b70c0e74080ecdd3266adc53f6'
3. UPDATE `mboxpro_session`
   SET `time`='1414756098',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
   WHERE session_id='489c59b70c0e74080ecdd3266adc53f6'
4. SELECT *
   FROM mboxpro_components
   WHERE parent = 0
5. SELECT folder AS type, element AS name, params
   FROM mboxpro_plugins
   WHERE published >= 1
   AND access <= 0
   ORDER BY ordering
6. SELECT template
   FROM mboxpro_templates_menu
   WHERE client_id = 0
   AND (menuid = 0 OR menuid = 1)
   ORDER BY menuid DESC
   LIMIT 0, 1
7. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.titleAS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
   FROM mboxpro_content AS a
   INNER JOIN mboxpro_content_frontpage AS f
   ON f.content_id = a.id
   LEFT JOIN mboxpro_categories AS cc
   ON cc.id = a.catid
   LEFT JOIN mboxpro_sections AS s
   ON s.id = a.sectionid
   LEFT JOIN mboxpro_users AS u
   ON u.id = a.created_by
   LEFT JOIN mboxpro_groups AS g
   ON a.access = g.id
   LEFT JOIN mboxpro_content_rating AS v
   ON a.id = v.content_id
   WHERE 1
   AND a.state = 1
   AND (( cc.published = 1
   AND s.published = 1 ) OR ( a.catid = 0
   AND a.sectionid = 0 ) )
   AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 11:48:18' )
   AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 11:48:18' )
   ORDER BY a.created DESC
   LIMIT 0, 21
8. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.titleAS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
   FROM mboxpro_content AS a
   INNER JOIN mboxpro_content_frontpage AS f
   ON f.content_id = a.id
   LEFT JOIN mboxpro_categories AS cc
   ON cc.id = a.catid
   LEFT JOIN mboxpro_sections AS s
   ON s.id = a.sectionid
   LEFT JOIN mboxpro_users AS u
   ON u.id = a.created_by
   LEFT JOIN mboxpro_groups AS g
   ON a.access = g.id
   LEFT JOIN mboxpro_content_rating AS v
   ON a.id = v.content_id
   WHERE 1
   AND a.state = 1
   AND (( cc.published = 1
   AND s.published = 1 ) OR ( a.catid = 0
   AND a.sectionid = 0 ) )
   AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 11:48:18' )
   AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 11:48:18' )
   ORDER BY a.created DESC
9. SELECT id, title, module, position, content, showtitle, control, params
   FROM mboxpro_modules AS m
   LEFT JOIN mboxpro_modules_menu AS mm
   ON mm.moduleid = m.id
   WHERE m.published = 1
   AND m.access <= 0
   AND m.client_id = 0
   AND ( mm.menuid = 1 OR mm.menuid = 0 )
   ORDER BY position, ordering
10. SELECT parent, menutype, ordering
    FROM mboxpro_menu
    WHERE id = 1
    LIMIT 1
11. SELECT count(*)
    FROM mboxpro_menu AS m
    WHERE menutype='mainmenu'
    AND published=1
    AND parent=0
    AND ordering < 1
    AND access <= '0'

ЗАРЕГИСТРИРОВАНО ОБРАТНО-СОВМЕСТИМЫХ ЗАПРОСОВ - 0

 

Вообщем JHC удалять? Вот и я про то, что лог вроде бы нормальный. Хостер masterhost, вроде бы не самый паршивый. Так у хостера какой конкретно лог попросить? Не сокращенный типа, или вообще другой?

 

И каков вердикт, что делать? Хостер грозится отключить mysql