Несколько дней назад сайт начал серьезно перегружать бд однотипными запросами и хост начал ограничивать загрузку сайта. Они предоставили отчет по запросам, но понять откуда они идут так и не смог. Установлен Complete Seo , его отключение и\или удаление не помогло. Отключение сео чпу в настройках опенкарта так же не помогло.
Запросы -
sendto(11, "v\0\0\0\3SELECT redirect, language_i"..., 122, MSG_DONTWAIT, NULL, 0) = 122
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\2R\0\0\2\3def\16smitt8kc_ocar1\17oc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 201
sendto(11, "e\0\0\0\3SELECT * FROM oc_seo_url WH"..., 105, MSG_DONTWAIT, NULL, 0) = 105
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 405
sendto(11, "d\0\0\0\3SELECT * FROM oc_seo_url WH"..., 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 453
sendto(11, "d\0\0\0\3SELECT * FROM oc_seo_url WH"..., 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 444
sendto(11, "\320\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 468, MSG_DONTWAIT, NULL, 0) = 468
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 32768, MSG_DONTWAIT, NULL, NULL) = 61
sendto(11, "v\0\0\0\3SELECT redirect, language_i"..., 122, MSG_DONTWAIT, NULL, 0) = 122
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\2R\0\0\2\3def\16smitt8kc_ocar1\17oc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 201
sendto(11, "e\0\0\0\3SELECT * FROM oc_seo_url WH"..., 105, MSG_DONTWAIT, NULL, 0) = 105
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 405
sendto(11, "d\0\0\0\3SELECT * FROM oc_seo_url WH"..., 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 453
sendto(11, "d\0\0\0\3SELECT * FROM oc_seo_url WH"..., 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 446
sendto(11, "\320\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 468, MSG_DONTWAIT, NULL, 0) = 468
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 32768, MSG_DONTWAIT, NULL, NULL) = 60
sendto(11, "v\0\0\0\3SELECT redirect, language_i"..., 122, MSG_DONTWAIT, NULL, 0) = 122
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\2R\0\0\2\3def\16smitt8kc_ocar1\17oc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 201
sendto(11, "e\0\0\0\3SELECT * FROM oc_seo_url WH"..., 105, MSG_DONTWAIT, NULL, 0) = 105
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 405
sendto(11, "d\0\0\0\3SELECT * FROM oc_seo_url WH"..., 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 453
sendto(11, "d\0\0\0\3SELECT * FROM oc_seo_url WH"..., 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\5L\0\0\2\3def\16smitt8kc_ocar1\noc_"..., 32768, MSG_DONTWAIT, NULL, NULL) = 454
sendto(11, "\320\1\0\0\3SELECT COUNT(DISTINCT p.pro"..., 468, MSG_DONTWAIT, NULL, 0) = 468
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\1\33\0\0\2\3def\0\0\0\5total\0\f?\0\25\0\0\0\10\201"..., 32768, MSG_DONTWAIT, NULL, NULL) = 62