медленная загрузка сайта из-за большого количества SQL-запросов

[Stroymirpro]

Помогите разобраться. Заметили, что на сайте очень медленно загружаются страницы. Написали в хостинг-поддержку. Пришел вот такой ответ: 

" Проблема связана с использованием, при загрузке страницы, большого количества SQL-запросов LEFT JOIN, пример:
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '175' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 14232, MSG_DONTWAIT, NULL, NULL) = 12362
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '203' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 1870, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '150' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 389, MSG_DONTWAIT, NULL, NULL) = 389
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "der\f?\0\3\0\0\0\3\1\0\0\0\0<\0\0\10\3def\16u0304664_stroy\1c\voc_category\6status\6status\f?\0\1\0\0\0\1\1\20\0\0\0D\0\0\t\3def\16u0304664_stroy\1c\voc_category\ndate_added\ndate_added\f?\0\23\0\0\0\f\201\0\0\0\0J\0\0\n\3def\16u0304664_stroy\1c\voc_category\rdate_modified\rdate_modified\f?\0\23\0\0\0\f\201\0\0\0\0S\0\0\v\3def\16u0304664_stroy\2c"..., 27981, MSG_DONTWAIT, NULL, NULL) = 5057
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '204' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 22924, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '174' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 21443, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '156' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 19962, MSG_DONTWAIT, NULL, NULL) = 7241
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '200' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 12721, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '192' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 11240, MSG_DONTWAIT, NULL, NULL) = 5738
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '201' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 5502, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '172' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 4021, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '206' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 2540, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '208' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 1059, MSG_DONTWAIT, NULL, NULL) = 1059
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "u0304664_stroy\2cd\27oc_category_description\fmeta_keyword\fmeta_keyword\f!\0\375\2\0\0\375\0\20\0\0\0O\0\0\21\3def\16u0304664_stroy\2cd\27oc_category_description\tseo_title\tseo_title\f!\0\375\2\0\0\375\0\20\0\0\0I\0\0\22\3def\16u0304664_stroy\2cd\27oc_category_description\6seo_h1\6seo_h1\f!\0\375\2\0\0\375\0\20\0\0\0Q\0\0\23\3def\16u03046"..., 27981, MSG_DONTWAIT, NULL, NULL) = 422
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '173' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 27559, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '148' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 26078, MSG_DONTWAIT, NULL, NULL) = 2121
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '205' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 23957, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '202' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 22476, MSG_DONTWAIT, NULL, NULL) = 1481
sendto(5, "1\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '207' AND cd.language_id = '1' AND c2s.store_id = '0' AN"..., 309, MSG_DONTWAIT, NULL, 0) = 309
poll([{fd=5, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "\1\0\0\1\23F\0\0\2\3def\16u0304664_stroy\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1\0\0\0\0:\0\0\3\3def\16u0304664_stroy\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\0B\0\0\4\3def\16u0304664_stroy\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0006\0\0\5\3def\16u0304664_stroy\1c\voc_category\3top\3to"..., 20995, MSG_DONTWAIT, NULL, NULL) = 1481

При этом ответ сервера быстрый(0,191сек):
curl -o /dev/null -k -s -w 'time_connect\t\t%{time_connect}\ntime_starttransfer\t%{time_starttransfer}\ntime_total\t\t%{time_total}\nhttp_code\t\t%{http_code}\nsize_download\t\t%{size_download}\n' http://stroymir.pro
time_connect 0,191
time_starttransfer 7,388
time_total 7,528
http_code 200
size_download 77668 "

 

Каким образом это можно исправить? 

[Otvet]

дерево категорий строит

[Stroymirpro]

18 минут назад, Otvet сказал:

дерево категорий строит

А что с этим можно сделать? Пока поправила строки отвечающие за подсчет категорий в файлах header.php и category.php

[Otvet]

кешировать блок, убирать дубль меню (не только по причине лишней нагрузки)