Нагрузка mysql

iMedia Ultimate

 
Посетитель
small user social cms
Медаль
Сообщений: 139
Сегодня утром поехал на работу, в электричке еду тихо мирно, захожу на сайт
а там такая картина:
Cannot connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Сразу с мобилы пишу хостеру ipserver

(честно рад что быстро там отвечают)

Ответ хостера:
Причина: out of memory.
Рекомендуем добавить ОЗУ для нормальной работы сайтов.

Я добавил 1024MB - $4/мес ОЗУ к текущему тарифу ниже скрин

Нагрузка mysql

Спрашиваю в тикете у хостера почему такая нагрузка потребление памяти.

Хостер написал это: На данный момент больше всего используют ресурсы mysql и веб сервера

И так посещалка сайта вчера была 4300 сегодня уже меньше. (Понятно утром с ночи лежал)
На сайте только видео с ютуба, спарсиного и некоторые юзеры вставляют по коду.

График в панели Vesta (ежедневный график)

Общая нагрузка
Нагрузка mysql

Использование памяти
Нагрузка mysql

Веб сервер
Нагрузка mysql

Сервер базы данных MySQL
Нагрузка mysql


Как быть где что искать? 17 баксов многовато точнее 15$ 2$ ip это отдельно.

Версия InstantVideo v1.8.3 © 2011-2015 на базе InstantCMS v1.10.3

Компоненты которые включены
1. Комментарии пользователей
2. Карта сайта
3. Видео каталог
4. Геолокация
5. Подписки
6. Голосования
7. Награждение пользователей
8. Регистрация
9. RSS генератор
10 Вопросы и ответы
11 Блоги
12 Профили пользователей
13 Каталог статей
14 Фотогалерея

Плагины включены:
Пинг поисковых систем
Видеоролики по теме
Проверка доступности ролика
Imperavi Redactor
Похожие ролики
BB code кнопка вставки видео
Канал пользователя в профиле
Стоп СпамБот

Модули включены:
Меню InstantCMS team
InstantVideo: Поиск видео
Меню пользователя
Статистика пользователей
InstantVideo: Выбор редакции
InstantVideo: Категории роликов
InstantVideo: Видеоролики
InstantVideo: Рубрики категорий
LogReg
И 6 штук внешних файлов для рекламы.

Вот что хостер написал

Можно включить slow_log и просматривать все запросы, выполняющиеся более определённого времени.

и уже накопилась в логе куча всего:
Редактировалось: 2 раз (Последний: 3 ноября 2015 в 23:10)
Сервер раст
Посетитель
small user social cms
Медаль
Сообщений: 139
wils:


Вот что хостер написал

Можно включить slow_log и просматривать все запросы, выполняющиеся более определённого времени.

и уже накопилась в логе куча всего:

хотя лучше код много весит
Код PHP:
  1. /usr/libexec/mysqld, Version: 5.5.45-log (MySQL Community Server (GPL) by Remi). started with:
  2. Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
  3. Time Id Command Argument
  4. # Time: 151103 21:59:35
  5. # [email protected]: логин бд[логин бд] @ localhost []
  6. # Query_time: 0.000449 Lock_time: 0.000157 Rows_sent: 18 Rows_examined: 36
  7. use admin_yutub;
  8. SET timestamp=1446577175;
  9. SELECT * FROM cms_menu ORDER BY id ASC;
  10. # [email protected]: логин бд[логин бд] @ localhost []
  11. # Query_time: 0.000238 Lock_time: 0.000095 Rows_sent: 26 Rows_examined: 52
  12. SET timestamp=1446577175;
  13. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  14. # [email protected]: логин бд[логин бд] @ localhost []
  15. # Query_time: 0.000449 Lock_time: 0.000176 Rows_sent: 19 Rows_examined: 86
  16. SET timestamp=1446577175;
  17. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  18. # [email protected]: логин бд[логин бд] @ localhost []
  19. # Query_time: 0.000261 Lock_time: 0.000175 Rows_sent: 1 Rows_examined: 4
  20. SET timestamp=1446577175;
  21. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  22. # [email protected]: логин бд[логин бд] @ localhost []
  23. # Query_time: 0.000145 Lock_time: 0.000034 Rows_sent: 0 Rows_examined: 26
  24. SET timestamp=1446577175;
  25. DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE) LIMIT 5;
  26. # [email protected]: логин бд[логин бд] @ localhost []
  27. # Query_time: 0.000122 Lock_time: 0.000014 Rows_sent: 26 Rows_examined: 26
  28. SET timestamp=1446577175;
  29. SELECT * FROM cms_online;
  30. # [email protected]: логин бд[логин бд] @ localhost []
  31. # Query_time: 0.000337 Lock_time: 0.000186 Rows_sent: 0 Rows_examined: 2
  32. SET timestamp=1446577175;
  33. SELECT a.* FROM cms_video_advertising a
  34. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.ordering > '2' AND a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  35. # [email protected]: логин бд[логин бд] @ localhost []
  36. # Query_time: 0.000153 Lock_time: 0.000040 Rows_sent: 0 Rows_examined: 2
  37. SET timestamp=1446577175;
  38. SELECT a.* FROM cms_video_advertising a
  39. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  40. # [email protected]: логин бд[логин бд] @ localhost []
  41. # Query_time: 0.000203 Lock_time: 0.000049 Rows_sent: 18 Rows_examined: 36
  42. SET timestamp=1446577175;
  43. SELECT * FROM cms_menu ORDER BY id ASC;
  44. # [email protected]: логин бд[логин бд] @ localhost []
  45. # Query_time: 0.000188 Lock_time: 0.000036 Rows_sent: 26 Rows_examined: 52
  46. SET timestamp=1446577175;
  47. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  48. # [email protected]: логин бд[логин бд] @ localhost []
  49. # Query_time: 0.000190 Lock_time: 0.000030 Rows_sent: 19 Rows_examined: 86
  50. SET timestamp=1446577175;
  51. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  52. # [email protected]: логин бд[логин бд] @ localhost []
  53. # Query_time: 0.000158 Lock_time: 0.000066 Rows_sent: 1 Rows_examined: 4
  54. SET timestamp=1446577175;
  55. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  56. # [email protected]: логин бд[логин бд] @ localhost []
  57. # Query_time: 0.000164 Lock_time: 0.000044 Rows_sent: 0 Rows_examined: 2
  58. SET timestamp=1446577175;
  59. SELECT a.* FROM cms_video_advertising a
  60. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '19' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  61. # [email protected]: логин бд[логин бд] @ localhost []
  62. # Query_time: 0.000157 Lock_time: 0.000033 Rows_sent: 18 Rows_examined: 36
  63. SET timestamp=1446577175;
  64. SELECT * FROM cms_menu ORDER BY id ASC;
  65. # [email protected]: логин бд[логин бд] @ localhost []
  66. # Query_time: 0.000251 Lock_time: 0.000049 Rows_sent: 26 Rows_examined: 52
  67. SET timestamp=1446577175;
  68. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  69. # [email protected]: логин бд[логин бд] @ localhost []
  70. # Query_time: 0.000329 Lock_time: 0.000045 Rows_sent: 19 Rows_examined: 86
  71. SET timestamp=1446577175;
  72. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  73. # [email protected]: логин бд[логин бд] @ localhost []
  74. # Query_time: 0.000165 Lock_time: 0.000071 Rows_sent: 1 Rows_examined: 4
  75. SET timestamp=1446577175;
  76. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  77. # [email protected]: логин бд[логин бд] @ localhost []
  78. # Query_time: 0.000144 Lock_time: 0.000033 Rows_sent: 0 Rows_examined: 26
  79. SET timestamp=1446577175;
  80. DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE) LIMIT 5;
  81. # [email protected]: логин бд[логин бд] @ localhost []
  82. # Query_time: 0.000160 Lock_time: 0.000030 Rows_sent: 26 Rows_examined: 26
  83. SET timestamp=1446577175;
  84. SELECT * FROM cms_online;
  85. # [email protected]: логин бд[логин бд] @ localhost []
  86. # Query_time: 0.000181 Lock_time: 0.000046 Rows_sent: 0 Rows_examined: 2
  87. SET timestamp=1446577175;
  88. SELECT a.* FROM cms_video_advertising a
  89. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.ordering > '2' AND a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  90. # [email protected]: логин бд[логин бд] @ localhost []
  91. # Query_time: 0.000137 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 2
  92. SET timestamp=1446577175;
  93. SELECT a.* FROM cms_video_advertising a
  94. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  95. # Time: 151103 21:59:37
  96. # [email protected]: логин бд[логин бд] @ localhost []
  97. # Query_time: 0.000238 Lock_time: 0.000026 Rows_sent: 19 Rows_examined: 39
  98. SET timestamp=1446577177;
  99. SELECT *
  100. FROM cms_video_category
  101. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  102. ORDER BY NSLeft, ordering;
  103. # [email protected]: логин бд[логин бд] @ localhost []
  104. # Query_time: 0.000293 Lock_time: 0.000188 Rows_sent: 0 Rows_examined: 4
  105. SET timestamp=1446577177;
  106. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  107. # [email protected]: логин бд[логин бд] @ localhost []
  108. # Query_time: 0.000102 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 4
  109. SET timestamp=1446577177;
  110. DELETE FROM cms_cache WHERE target='module' AND target_id='1';
  111. # [email protected]: логин бд[логин бд] @ localhost []
  112. # Query_time: 0.000209 Lock_time: 0.000123 Rows_sent: 4 Rows_examined: 11
  113. SET timestamp=1446577177;
  114. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  115. # [email protected]: логин бд[логин бд] @ localhost []
  116. # Query_time: 0.000319 Lock_time: 0.000050 Rows_sent: 19 Rows_examined: 39
  117. SET timestamp=1446577177;
  118. SELECT *
  119. FROM cms_video_category
  120. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  121. ORDER BY NSLeft, ordering;
  122. # [email protected]: логин бд[логин бд] @ localhost []
  123. # Query_time: 0.000242 Lock_time: 0.000118 Rows_sent: 1 Rows_examined: 3
  124. SET timestamp=1446577177;
  125. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  126. # [email protected]: логин бд[логин бд] @ localhost []
  127. # Query_time: 0.000100 Lock_time: 0.000041 Rows_sent: 1 Rows_examined: 3
  128. SET timestamp=1446577177;
  129. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  130. # [email protected]: логин бд[логин бд] @ localhost []
  131. # Query_time: 0.000106 Lock_time: 0.000029 Rows_sent: 4 Rows_examined: 11
  132. SET timestamp=1446577177;
  133. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  134. # [email protected]: логин бд[логин бд] @ localhost []
  135. # Query_time: 0.000271 Lock_time: 0.000035 Rows_sent: 19 Rows_examined: 39
  136. SET timestamp=1446577177;
  137. SELECT *
  138. FROM cms_video_category
  139. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  140. ORDER BY NSLeft, ordering;
  141. # [email protected]: логин бд[логин бд] @ localhost []
  142. # Query_time: 0.000202 Lock_time: 0.000080 Rows_sent: 1 Rows_examined: 3
  143. SET timestamp=1446577177;
  144. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  145. # [email protected]: логин бд[логин бд] @ localhost []
  146. # Query_time: 0.000072 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 3
  147. SET timestamp=1446577177;
  148. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  149. # [email protected]: логин бд[логин бд] @ localhost []
  150. # Query_time: 0.000131 Lock_time: 0.000043 Rows_sent: 4 Rows_examined: 11
  151. SET timestamp=1446577177;
  152. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  153. # [email protected]: логин бд[логин бд] @ localhost []
  154. # Query_time: 0.000595 Lock_time: 0.000037 Rows_sent: 18 Rows_examined: 36
  155. SET timestamp=1446577177;
  156. SELECT * FROM cms_menu ORDER BY id ASC;
  157. # [email protected]: логин бд[логин бд] @ localhost []
  158. # Query_time: 0.000265 Lock_time: 0.000030 Rows_sent: 26 Rows_examined: 52
  159. SET timestamp=1446577177;
  160. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  161. # [email protected]: логин бд[логин бд] @ localhost []
  162. # Query_time: 0.002954 Lock_time: 0.000032 Rows_sent: 19 Rows_examined: 86
  163. SET timestamp=1446577177;
  164. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  165. # [email protected]: логин бд[логин бд] @ localhost []
  166. # Query_time: 0.000176 Lock_time: 0.000072 Rows_sent: 1 Rows_examined: 4
  167. SET timestamp=1446577177;
  168. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  169. # [email protected]: логин бд[логин бд] @ localhost []
  170. # Query_time: 0.000200 Lock_time: 0.000057 Rows_sent: 0 Rows_examined: 2
  171. SET timestamp=1446577177;
  172. SELECT a.* FROM cms_video_advertising a
  173. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '16' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  174. # Time: 151103 21:59:38
  175. # [email protected]: логин бд[логин бд] @ localhost []
  176. # Query_time: 0.000264 Lock_time: 0.000031 Rows_sent: 19 Rows_examined: 39
  177. SET timestamp=1446577178;
  178. SELECT *
  179. FROM cms_video_category
  180. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  181. ORDER BY NSLeft, ordering;
  182. # [email protected]: логин бд[логин бд] @ localhost []
  183. # Query_time: 0.000168 Lock_time: 0.000068 Rows_sent: 1 Rows_examined: 3
  184. SET timestamp=1446577178;
  185. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  186. # [email protected]: логин бд[логин бд] @ localhost []
  187. # Query_time: 0.000064 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 3
  188. SET timestamp=1446577178;
  189. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  190. # [email protected]: логин бд[логин бд] @ localhost []
  191. # Query_time: 0.000088 Lock_time: 0.000021 Rows_sent: 4 Rows_examined: 11
  192. SET timestamp=1446577178;
  193. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  194. # [email protected]: логин бд[логин бд] @ localhost []
  195. # Query_time: 0.000333 Lock_time: 0.000036 Rows_sent: 18 Rows_examined: 36
  196. SET timestamp=1446577178;
  197. SELECT * FROM cms_menu ORDER BY id ASC;
  198. # [email protected]: логин бд[логин бд] @ localhost []
  199. # Query_time: 0.000248 Lock_time: 0.000027 Rows_sent: 26 Rows_examined: 52
  200. SET timestamp=1446577178;
  201. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  202. # [email protected]: логин бд[логин бд] @ localhost []
  203. # Query_time: 0.003205 Lock_time: 0.000030 Rows_sent: 19 Rows_examined: 86
  204. SET timestamp=1446577178;
  205. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  206. # [email protected]: логин бд[логин бд] @ localhost []
  207. # Query_time: 0.000111 Lock_time: 0.000043 Rows_sent: 1 Rows_examined: 4
  208. SET timestamp=1446577178;
  209. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  210. # [email protected]: логин бд[логин бд] @ localhost []
  211. # Query_time: 0.000189 Lock_time: 0.000069 Rows_sent: 1 Rows_examined: 1
  212. SET timestamp=1446577178;
  213. SELECT * FROM cms_video_category WHERE NSLevel = 0 ORDER BY id ASC LIMIT 1;
  214. # [email protected]: логин бд[логин бд] @ localhost []
  215. # Query_time: 0.000258 Lock_time: 0.000026 Rows_sent: 19 Rows_examined: 39
  216. SET timestamp=1446577178;
  217. SELECT *
  218. FROM cms_video_category
  219. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  220. ORDER BY NSLeft, ordering;
  221. # [email protected]: логин бд[логин бд] @ localhost []
  222. # Query_time: 0.057493 Lock_time: 0.000036 Rows_sent: 18096 Rows_examined: 18116
  223. SET timestamp=1446577178;
  224. SELECT m.id
  225.  
  226. FROM cms_video_movie m
  227. INNER JOIN cms_video_category cat ON cat.id = m.cat_id
  228.  
  229. WHERE m.published = 1
  230. AND (m.status = '0')
  231. AND (m.allow_who = 'all');
  232. # [email protected]: логин бд[логин бд] @ localhost []
  233. # Query_time: 0.000544 Lock_time: 0.000093 Rows_sent: 9 Rows_examined: 93
  234. SET timestamp=1446577178;
  235. SELECT m.*, mb.position as mb_position
  236. FROM cms_modules m
  237. INNER JOIN cms_modules_bind mb ON mb.module_id = m.id AND mb.menu_id IN (1, 0)
  238. WHERE m.published = 1
  239. ORDER BY m.ordering ASC;
  240. # [email protected]: логин бд[логин бд] @ localhost []
  241. # Query_time: 0.000339 Lock_time: 0.000035 Rows_sent: 19 Rows_examined: 39
  242. SET timestamp=1446577178;
  243. SELECT *
  244. FROM cms_video_category
  245. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  246. ORDER BY NSLeft, ordering;
  247. # [email protected]: логин бд[логин бд] @ localhost []
  248. # Query_time: 0.000136 Lock_time: 0.000054 Rows_sent: 1 Rows_examined: 4
  249. SET timestamp=1446577178;
  250. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='90' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  251. # [email protected]: логин бд[логин бд] @ localhost []
  252. # Query_time: 0.000070 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 4
  253. SET timestamp=1446577178;
  254. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='90' LIMIT 1;
  255. # [email protected]: логин бд[логин бд] @ localhost []
  256. # Query_time: 0.000554 Lock_time: 0.000042 Rows_sent: 5 Rows_examined: 20
  257. SET timestamp=1446577178;
  258. SELECT r.*
  259. FROM cms_video_rubric r
  260. LEFT JOIN cms_video_bind b ON b.rubric_id = r.id AND b.target = 'rubric'
  261. WHERE is_user_channel = 0 AND r.published=1
  262. GROUP BY r.id
  263. ORDER BY r.r_group ASC, r.rating DESC LIMIT 0, 5;
  264. # [email protected]: логин бд[логин бд] @ localhost []
  265. # Query_time: 0.000194 Lock_time: 0.000073 Rows_sent: 1 Rows_examined: 3
  266. SET timestamp=1446577178;
  267. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  268. # [email protected]: логин бд[логин бд] @ localhost []
  269. # Query_time: 0.000053 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 3
  270. SET timestamp=1446577178;
  271. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  272. # [email protected]: логин бд[логин бд] @ localhost []
  273. # Query_time: 0.000080 Lock_time: 0.000022 Rows_sent: 4 Rows_examined: 11
  274. SET timestamp=1446577178;
  275. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  276. # [email protected]: логин бд[логин бд] @ localhost []
  277. # Query_time: 0.000618 Lock_time: 0.000039 Rows_sent: 18 Rows_examined: 36
  278. SET timestamp=1446577178;
  279. SELECT * FROM cms_menu ORDER BY id ASC;
  280. # [email protected]: логин бд[логин бд] @ localhost []
  281. # Query_time: 0.000278 Lock_time: 0.000029 Rows_sent: 26 Rows_examined: 52
  282. SET timestamp=1446577178;
  283. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  284. # [email protected]: логин бд[логин бд] @ localhost []
  285. # Query_time: 0.002902 Lock_time: 0.000041 Rows_sent: 19 Rows_examined: 86
  286. SET timestamp=1446577178;
  287. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  288. # [email protected]: логин бд[логин бд] @ localhost []
  289. # Query_time: 0.000144 Lock_time: 0.000057 Rows_sent: 1 Rows_examined: 4
  290. SET timestamp=1446577178;
  291. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  292. # [email protected]: логин бд[логин бд] @ localhost []
  293. # Query_time: 0.000135 Lock_time: 0.000024 Rows_sent: 0 Rows_examined: 26
  294. SET timestamp=1446577178;
  295. DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE) LIMIT 5;
  296. # [email protected]: логин бд[логин бд] @ localhost []
  297. # Query_time: 0.000135 Lock_time: 0.000018 Rows_sent: 25 Rows_examined: 25
  298. SET timestamp=1446577178;
  299. SELECT * FROM cms_online;
  300. # [email protected]: логин бд[логин бд] @ localhost []
  301. # Query_time: 0.000156 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 21
  302. SET timestamp=1446577178;
  303. SELECT * FROM cms_video_category WHERE NSLeft <= 18 AND NSRight >= 19 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft;
  304. # [email protected]: логин бд[логин бд] @ localhost []
  305. # Query_time: 0.000134 Lock_time: 0.000024 Rows_sent: 0 Rows_examined: 20
  306. SET timestamp=1446577178;
  307. SELECT *
  308. FROM cms_video_category
  309. WHERE parent_id > 0 AND NSLeft > 18 AND NSRight < 19 AND published = 1
  310. ORDER BY NSLeft, ordering;
  311. # [email protected]: логин бд[логин бд] @ localhost []
  312. # Query_time: 0.000185 Lock_time: 0.000031 Rows_sent: 18 Rows_examined: 36
  313. SET timestamp=1446577178;
  314. SELECT * FROM cms_menu ORDER BY id ASC;
  315. # [email protected]: логин бд[логин бд] @ localhost []
  316. # Query_time: 0.000157 Lock_time: 0.000027 Rows_sent: 26 Rows_examined: 52
  317. SET timestamp=1446577178;
  318. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  319. # [email protected]: логин бд[логин бд] @ localhost []
  320. # Query_time: 0.000318 Lock_time: 0.000040 Rows_sent: 19 Rows_examined: 86
  321. SET timestamp=1446577178;
  322. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  323. # [email protected]: логин бд[логин бд] @ localhost []
  324. # Query_time: 0.000151 Lock_time: 0.000061 Rows_sent: 1 Rows_examined: 4
  325. SET timestamp=1446577178;
  326. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  327. # [email protected]: логин бд[логин бд] @ localhost []
  328. # Query_time: 0.000475 Lock_time: 0.000068 Rows_sent: 0 Rows_examined: 10
  329. SET timestamp=1446577178;
  330. SELECT r.*
  331. FROM cms_video_rubric r
  332. LEFT JOIN cms_video_bind b ON b.rubric_id = r.id AND b.target = 'rubric'
  333. WHERE is_user_channel = 0 AND r.published=1 AND b.cat_id='22' OR r.bind_all = 1
  334. GROUP BY r.id
  335. ORDER BY r.r_group ASC, r.title;
  336. # [email protected]: логин бд[логин бд] @ localhost []
  337. # Query_time: 0.000245 Lock_time: 0.000034 Rows_sent: 19 Rows_examined: 39
  338. SET timestamp=1446577178;
  339. SELECT *
  340. FROM cms_video_category
  341. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  342. ORDER BY NSLeft, ordering;
  343. # [email protected]: логин бд[логин бд] @ localhost []
  344. # Query_time: 0.000177 Lock_time: 0.000071 Rows_sent: 1 Rows_examined: 3
  345. SET timestamp=1446577178;
  346. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  347. # [email protected]: логин бд[логин бд] @ localhost []
  348. # Query_time: 0.000064 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 3
  349. SET timestamp=1446577178;
  350. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  351. # [email protected]: логин бд[логин бд] @ localhost []
  352. # Query_time: 0.000098 Lock_time: 0.000022 Rows_sent: 4 Rows_examined: 11
  353. SET timestamp=1446577178;
  354. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  355. # [email protected]: логин бд[логин бд] @ localhost []
  356. # Query_time: 0.000152 Lock_time: 0.000045 Rows_sent: 0 Rows_examined: 2
  357. SET timestamp=1446577178;
  358. SELECT a.* FROM cms_video_advertising a
  359. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  360. # Time: 151103 21:59:39
  361. # [email protected]: логин бд[логин бд] @ localhost []
  362. # Query_time: 0.000173 Lock_time: 0.000038 Rows_sent: 18 Rows_examined: 36
  363. SET timestamp=1446577179;
  364. SELECT * FROM cms_menu ORDER BY id ASC;
  365. # [email protected]: логин бд[логин бд] @ localhost []
  366. # Query_time: 0.000177 Lock_time: 0.000034 Rows_sent: 26 Rows_examined: 52
  367. SET timestamp=1446577179;
  368. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  369. # [email protected]: логин бд[логин бд] @ localhost []
  370. # Query_time: 0.000279 Lock_time: 0.000056 Rows_sent: 19 Rows_examined: 86
  371. SET timestamp=1446577179;
  372. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  373. # [email protected]: логин бд[логин бд] @ localhost []
  374. # Query_time: 0.000135 Lock_time: 0.000059 Rows_sent: 1 Rows_examined: 4
  375. SET timestamp=1446577179;
  376. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  377. # [email protected]: логин бд[логин бд] @ localhost []
  378. # Query_time: 0.000160 Lock_time: 0.000045 Rows_sent: 0 Rows_examined: 25
  379. SET timestamp=1446577179;
  380. DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE) LIMIT 5;
  381. # [email protected]: логин бд[логин бд] @ localhost []
  382. # Query_time: 0.000157 Lock_time: 0.000018 Rows_sent: 25 Rows_examined: 25
  383. SET timestamp=1446577179;
  384. SELECT * FROM cms_online;
  385. # [email protected]: логин бд[логин бд] @ localhost []
  386. # Query_time: 0.000200 Lock_time: 0.000078 Rows_sent: 0 Rows_examined: 2
  387. SET timestamp=1446577179;
  388. SELECT a.* FROM cms_video_advertising a
  389. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.ordering > '2' AND a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  390. # [email protected]: логин бд[логин бд] @ localhost []
  391. # Query_time: 0.000191 Lock_time: 0.000055 Rows_sent: 0 Rows_examined: 2
  392. SET timestamp=1446577179;
  393. SELECT a.* FROM cms_video_advertising a
  394. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  395. # [email protected]: логин бд[логин бд] @ localhost []
  396. # Query_time: 0.000240 Lock_time: 0.000045 Rows_sent: 18 Rows_examined: 36
  397. SET timestamp=1446577179;
  398. SELECT * FROM cms_menu ORDER BY id ASC;
  399. # [email protected]: логин бд[логин бд] @ localhost []
  400. # Query_time: 0.000222 Lock_time: 0.000040 Rows_sent: 26 Rows_examined: 52
  401. SET timestamp=1446577179;
  402. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  403. # [email protected]: логин бд[логин бд] @ localhost []
  404. # Query_time: 0.000321 Lock_time: 0.000042 Rows_sent: 19 Rows_examined: 86
  405. SET timestamp=1446577179;
  406. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  407. # [email protected]: логин бд[логин бд] @ localhost []
  408. # Query_time: 0.000139 Lock_time: 0.000061 Rows_sent: 1 Rows_examined: 4
  409. SET timestamp=1446577179;
  410. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  411. # [email protected]: логин бд[логин бд] @ localhost []
  412. # Query_time: 0.000254 Lock_time: 0.000065 Rows_sent: 0 Rows_examined: 2
  413. SET timestamp=1446577179;
  414. SELECT a.* FROM cms_video_advertising a
  415. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.ordering > '2' AND a.user_type IN (0,1) AND a.position=0 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  416. # [email protected]: логин бд[логин бд] @ localhost []
  417. # Query_time: 0.000185 Lock_time: 0.000053 Rows_sent: 0 Rows_examined: 2
  418. SET timestamp=1446577179;
  419. SELECT a.* FROM cms_video_advertising a
  420. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=0 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  421. # [email protected]: логин бд[логин бд] @ localhost []
  422. # Query_time: 0.000316 Lock_time: 0.000059 Rows_sent: 19 Rows_examined: 39
  423. SET timestamp=1446577179;
  424. SELECT *
  425. FROM cms_video_category
  426. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  427. ORDER BY NSLeft, ordering;
  428. # [email protected]: логин бд[логин бд] @ localhost []
  429. # Query_time: 0.000224 Lock_time: 0.000100 Rows_sent: 1 Rows_examined: 3
  430. SET timestamp=1446577179;
  431. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  432. # [email protected]: логин бд[логин бд] @ localhost []
  433. # Query_time: 0.000085 Lock_time: 0.000032 Rows_sent: 1 Rows_examined: 3
  434. SET timestamp=1446577179;
  435. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  436. # [email protected]: логин бд[логин бд] @ localhost []
  437. # Query_time: 0.000106 Lock_time: 0.000025 Rows_sent: 4 Rows_examined: 11
  438. SET timestamp=1446577179;
  439. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  440. # Time: 151103 21:59:40
  441. # [email protected]: логин бд[логин бд] @ localhost []
  442. # Query_time: 0.000693 Lock_time: 0.000043 Rows_sent: 18 Rows_examined: 36
  443. SET timestamp=1446577180;
  444. SELECT * FROM cms_menu ORDER BY id ASC;
  445. # [email protected]: логин бд[логин бд] @ localhost []
  446. # Query_time: 0.000341 Lock_time: 0.000032 Rows_sent: 26 Rows_examined: 52
  447. SET timestamp=1446577180;
  448. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  449. # [email protected]: логин бд[логин бд] @ localhost []
  450. # Query_time: 0.009060 Lock_time: 0.000032 Rows_sent: 19 Rows_examined: 86
  451. SET timestamp=1446577180;
  452. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  453. # [email protected]: логин бд[логин бд] @ localhost []
  454. # Query_time: 0.000146 Lock_time: 0.000065 Rows_sent: 1 Rows_examined: 4
  455. SET timestamp=1446577180;
  456. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  457. # [email protected]: логин бд[логин бд] @ localhost []
  458. # Query_time: 0.000060 Lock_time: 0.000032 Rows_sent: 1 Rows_examined: 1
  459. SET timestamp=1446577180;
  460. SELECT LAST_INSERT_ID() as lastid FROM cms_video_service LIMIT 1;
  461. # [email protected]: логин бд[логин бд] @ localhost []
  462. # Query_time: 0.000142 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 2
  463. SET timestamp=1446577180;
  464. SELECT a.* FROM cms_video_advertising a
  465. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  466. # [email protected]: логин бд[логин бд] @ localhost []
  467. # Query_time: 0.000397 Lock_time: 0.000055 Rows_sent: 19 Rows_examined: 39
  468. SET timestamp=1446577180;
  469. SELECT *
  470. FROM cms_video_category
  471. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  472. ORDER BY NSLeft, ordering;
  473. # [email protected]: логин бд[логин бд] @ localhost []
  474. # Query_time: 0.000233 Lock_time: 0.000112 Rows_sent: 1 Rows_examined: 3
  475. SET timestamp=1446577180;
  476. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  477. # [email protected]: логин бд[логин бд] @ localhost []
  478. # Query_time: 0.000166 Lock_time: 0.000067 Rows_sent: 1 Rows_examined: 3
  479. SET timestamp=1446577180;
  480. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  481. # [email protected]: логин бд[логин бд] @ localhost []
  482. # Query_time: 0.000110 Lock_time: 0.000031 Rows_sent: 4 Rows_examined: 11
  483. SET timestamp=1446577180;
  484. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  485. # [email protected]: логин бд[логин бд] @ localhost []
  486. # Query_time: 0.000144 Lock_time: 0.000054 Rows_sent: 14 Rows_examined: 16
  487. SET timestamp=1446577180;
  488. SELECT name FROM cms_video_providers WHERE play_custom_player = 1;
  489. # Time: 151103 21:59:41
  490. # [email protected]: логин бд[логин бд] @ localhost []
  491. # Query_time: 0.000313 Lock_time: 0.000034 Rows_sent: 19 Rows_examined: 39
  492. SET timestamp=1446577181;
  493. SELECT *
  494. FROM cms_video_category
  495. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  496. ORDER BY NSLeft, ordering;
  497. # [email protected]: логин бд[логин бд] @ localhost []
  498. # Query_time: 0.000178 Lock_time: 0.000072 Rows_sent: 1 Rows_examined: 3
  499. SET timestamp=1446577181;
  500. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  501. # [email protected]: логин бд[логин бд] @ localhost []
  502. # Query_time: 0.000072 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 3
  503. SET timestamp=1446577181;
  504. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  505. # [email protected]: логин бд[логин бд] @ localhost []
  506. # Query_time: 0.000110 Lock_time: 0.000026 Rows_sent: 4 Rows_examined: 11
  507. SET timestamp=1446577181;
  508. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  509. # [email protected]: логин бд[логин бд] @ localhost []
  510. # Query_time: 0.000583 Lock_time: 0.000040 Rows_sent: 18 Rows_examined: 36
  511. SET timestamp=1446577181;
  512. SELECT * FROM cms_menu ORDER BY id ASC;
  513. # [email protected]: логин бд[логин бд] @ localhost []
  514. # Query_time: 0.000255 Lock_time: 0.000028 Rows_sent: 26 Rows_examined: 52
  515. SET timestamp=1446577181;
  516. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  517. # [email protected]: логин бд[логин бд] @ localhost []
  518. # Query_time: 0.003697 Lock_time: 0.000031 Rows_sent: 19 Rows_examined: 86
  519. SET timestamp=1446577181;
  520. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  521. # [email protected]: логин бд[логин бд] @ localhost []
  522. # Query_time: 0.000142 Lock_time: 0.000050 Rows_sent: 1 Rows_examined: 4
  523. SET timestamp=1446577181;
  524. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  525. # [email protected]: логин бд[логин бд] @ localhost []
  526. # Query_time: 0.000193 Lock_time: 0.000047 Rows_sent: 0 Rows_examined: 2
  527. SET timestamp=1446577181;
  528. SELECT a.* FROM cms_video_advertising a
  529. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  530. # [email protected]: логин бд[логин бд] @ localhost []
  531. # Query_time: 0.000247 Lock_time: 0.000027 Rows_sent: 19 Rows_examined: 39
  532. SET timestamp=1446577181;
  533. SELECT *
  534. FROM cms_video_category
  535. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  536. ORDER BY NSLeft, ordering;
  537. # [email protected]: логин бд[логин бд] @ localhost []
  538. # Query_time: 0.000191 Lock_time: 0.000073 Rows_sent: 1 Rows_examined: 3
  539. SET timestamp=1446577181;
  540. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  541. # [email protected]: логин бд[логин бд] @ localhost []
  542. # Query_time: 0.000072 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 3
  543. SET timestamp=1446577181;
  544. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  545. # [email protected]: логин бд[логин бд] @ localhost []
  546. # Query_time: 0.000113 Lock_time: 0.000028 Rows_sent: 4 Rows_examined: 11
  547. SET timestamp=1446577181;
  548. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  549. # [email protected]: логин бд[логин бд] @ localhost []
  550. # Query_time: 0.000667 Lock_time: 0.000037 Rows_sent: 18 Rows_examined: 36
  551. SET timestamp=1446577181;
  552. SELECT * FROM cms_menu ORDER BY id ASC;
  553. # [email protected]: логин бд[логин бд] @ localhost []
  554. # Query_time: 0.000311 Lock_time: 0.000035 Rows_sent: 26 Rows_examined: 52
  555. SET timestamp=1446577181;
  556. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  557. # [email protected]: логин бд[логин бд] @ localhost []
  558. # Query_time: 0.003307 Lock_time: 0.000034 Rows_sent: 19 Rows_examined: 86
  559. SET timestamp=1446577181;
  560. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  561. # [email protected]: логин бд[логин бд] @ localhost []
  562. # Query_time: 0.000146 Lock_time: 0.000062 Rows_sent: 1 Rows_examined: 4
  563. SET timestamp=1446577181;
  564. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  565. # Time: 151103 21:59:42
  566. # [email protected]: логин бд[логин бд] @ localhost []
  567. # Query_time: 0.000205 Lock_time: 0.000055 Rows_sent: 0 Rows_examined: 2
  568. SET timestamp=1446577182;
  569. SELECT a.* FROM cms_video_advertising a
  570. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '15' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  571. # [email protected]: логин бд[логин бд] @ localhost []
  572. # Query_time: 0.000236 Lock_time: 0.000026 Rows_sent: 19 Rows_examined: 39
  573. SET timestamp=1446577182;
  574. SELECT *
  575. FROM cms_video_category
  576. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  577. ORDER BY NSLeft, ordering;
  578. # [email protected]: логин бд[логин бд] @ localhost []
  579. # Query_time: 0.000212 Lock_time: 0.000089 Rows_sent: 1 Rows_examined: 3
  580. SET timestamp=1446577182;
  581. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  582. # [email protected]: логин бд[логин бд] @ localhost []
  583. # Query_time: 0.000074 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 3
  584. SET timestamp=1446577182;
  585. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  586. # [email protected]: логин бд[логин бд] @ localhost []
  587. # Query_time: 0.000114 Lock_time: 0.000029 Rows_sent: 4 Rows_examined: 11
  588. SET timestamp=1446577182;
  589. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  590. # [email protected]: логин бд[логин бд] @ localhost []
  591. # Query_time: 0.000601 Lock_time: 0.000041 Rows_sent: 18 Rows_examined: 36
  592. SET timestamp=1446577182;
  593. SELECT * FROM cms_menu ORDER BY id ASC;
  594. # [email protected]: логин бд[логин бд] @ localhost []
  595. # Query_time: 0.000300 Lock_time: 0.000028 Rows_sent: 26 Rows_examined: 52
  596. SET timestamp=1446577182;
  597. SELECT id, title, link, config, internal, published, version, system FROM cms_components WHERE 1=1 ORDER BY title;
  598. # [email protected]: логин бд[логин бд] @ localhost []
  599. # Query_time: 0.002768 Lock_time: 0.000033 Rows_sent: 19 Rows_examined: 86
  600. SET timestamp=1446577182;
  601. SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id;
  602. # [email protected]: логин бд[логин бд] @ localhost []
  603. # Query_time: 0.000128 Lock_time: 0.000056 Rows_sent: 1 Rows_examined: 4
  604. SET timestamp=1446577182;
  605. SELECT id, access FROM cms_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1;
  606. # [email protected]: логин бд[логин бд] @ localhost []
  607. # Query_time: 0.000153 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 21
  608. SET timestamp=1446577182;
  609. SELECT * FROM cms_video_category WHERE NSLeft <= 22 AND NSRight >= 23 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft;
  610. # [email protected]: логин бд[логин бд] @ localhost []
  611. # Query_time: 0.000206 Lock_time: 0.000061 Rows_sent: 0 Rows_examined: 2
  612. SET timestamp=1446577182;
  613. SELECT a.* FROM cms_video_advertising a
  614. LEFT JOIN cms_video_bind ab ON ab.ad_id = a.id AND ab.target = 'ad' WHERE a.user_type IN (0,1) AND a.position=2 AND a.time_of_day_start <= 21 AND a.time_of_day_end >= 21 AND a.published=1 AND (a.place = 1 OR (a.place = 0 AND (ab.cat_id = '24' ))) ORDER BY a.place DESC, a.ordering ASC LIMIT 1;
  615. # Time: 151103 21:59:43
  616. # [email protected]: логин бд[логин бд] @ localhost []
  617. # Query_time: 0.000249 Lock_time: 0.000027 Rows_sent: 19 Rows_examined: 39
  618. SET timestamp=1446577183;
  619. SELECT *
  620. FROM cms_video_category
  621. WHERE parent_id > 0 AND NSLeft > 1 AND NSRight < 40 AND published = 1
  622. ORDER BY NSLeft, ordering;
  623. # [email protected]: логин бд[логин бд] @ localhost []
  624. # Query_time: 0.000197 Lock_time: 0.000078 Rows_sent: 1 Rows_examined: 3
  625. SET timestamp=1446577183;
  626. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' AND cachedate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) LIMIT 1;
  627. # [email protected]: логин бд[логин бд] @ localhost []
  628. # Query_time: 0.000072 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 3
  629. SET timestamp=1446577183;
  630. SELECT cachefile as getfield FROM cms_cache WHERE target='module' AND target_id='1' LIMIT 1;
  631. # [email protected]: логин бд[логин бд] @ localhost []
  632. # Query_time: 0.000101 Lock_time: 0.000022 Rows_sent: 4 Rows_examined: 11
  633. SET timestamp=1446577183;
  634. SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC;
  635. # [email protected]: логин бд[логин бд] @ localhost []
  636. # Query_time: 0.000673 Lock_time: 0.000053 Rows_sent: 18 Rows_examined: 36
  637. SET timestamp=1446577183;
  638. SELECT * FROM cms_menu ORDER BY id ASC;
  639. # [email protected]: логин бд[логин бд] @ localhost []
  640. # Query_time: 0.000325 Lock_time: 0.000038 Rows_sent: 26 Rows_examined: 52
  641. SET timestamp=1446577183;
  642. SELECT id,
Редактировалось: 1 раз (Последний: 3 ноября 2015 в 23:18)
Сервер раст
Реклама
cms
Посетитель
small user social cms
МедальКубок зрительских симпатийАвторитет форума
Сообщений: 6473
Отключите похожие ролики, потестируйте. Если нужна будут мощности, могу разместить у себя недорого.
Хостинг и ВПС Халява тексты Стартапы Instantcms в Telegram
Посетитель
small user social cms
МедальКубок зрительских симпатийПочетный донор проекта
Сообщений: 820
В приведенном куске лога нет не одного тяжелого запроса.
Компоненты, модули, шаблоны, разработка на заказ - широкий выбор всего
Посетитель
small user social cms
Медаль
Сообщений: 139
maxisoft:

В приведенном куске лога нет не одного тяжелого запроса.
Как хостер сказал: это более длительные запросы по времени. Не ну 4300 хостов это ладно если 50000 скок мне надо будет тратится.. Че делать х3 похожие ролики выключил, это когда после проигрывания видео появляется список? Или то, что на странице ролика блок с права?
Сервер раст
В начало страницы
Предыдущая темаСледующая тема Перейти на форум:
Быстрый ответ
Чтобы писать на форуме, зарегистрируйтесь или авторизуйтесь.