SaveText.Ru

Без имени
  1. Здравствуйте!
  2.  
  3. При загрузке главной страницы вашего сайта идет огромное количество подобных запросов к MySQL:
  4.  
  5. [pid 23749] 15:54:40 poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=7, revents=POLLIN}])
  6. [pid 23749] 15:54:40 recvfrom(7, «1113323def5totalf?2510201533762340231553762», 1719, MSG_DONTWAIT, NULL, NULL) = 61
  7. [pid 23749] 15:54:40 sendto(7, «32013SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = „1“ AND p.status = „1“ AND p.date_available <= NOW() AND p2s.store_id = „0“ AND cp.path_id = „130“», 468, MSG_DONTWAIT, NULL, 0) = 468
  8. [pid 23749] 15:54:40 poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=7, revents=POLLIN}])
  9. [pid 23749] 15:54:40 recvfrom(7, «1113323def5totalf?2510201533762340256553762», 1658, MSG_DONTWAIT, NULL, NULL) = 61
  10. [pid 23749] 15:54:40 sendto(7, «32013SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = „1“ AND p.status = „1“ AND p.date_available <= NOW() AND p2s.store_id = „0“ AND cp.path_id = „217“», 468, MSG_DONTWAIT, NULL, 0) = 468
  11. [pid 23749] 15:54:40 poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=7, revents=POLLIN}])
  12. [pid 23749] 15:54:40 recvfrom(7, «1113323def5totalf?251020153376224011553762», 1597, MSG_DONTWAIT, NULL, NULL) = 60
  13. [pid 23749] 15:54:40 sendto(7, «31713SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = „1“ AND p.status = „1“ AND p.date_available <= NOW() AND p2s.store_id = „0“ AND cp.path_id = „62“», 467, MSG_DONTWAIT, NULL, 0) = 467
  14. [pid 23749] 15:54:40 poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=7, revents=POLLIN}])
  15. [pid 23749] 15:54:41 recvfrom(7, «1113323def5totalf?2510201533762340239553762», 1537, MSG_DONTWAIT, NULL, NULL) = 61
  16. [pid 23749] 15:54:41 sendto(7, «32013SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = „1“ AND p.status = „1“ AND p.date_available <= NOW() AND p2s.store_id = „0“ AND cp.path_id = „112“», 468, MSG_DONTWAIT, NULL, 0) = 468
  17. [pid 23749] 15:54:41 poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=7, revents=POLLIN}])
  18. [pid 23749] 15:54:41 recvfrom(7, «1113323def5totalf?2510201533762340235553762», 1476, MSG_DONTWAIT, NULL, NULL) = 61
  19. [pid 23749] 15:54:41 sendto(7, «32013SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = „1“ AND p.status = „1“ AND p.date_available <= NOW() AND p2s.store_id = „0“ AND cp.path_id = „265“», 468, MSG_DONTWAIT, NULL, 0) = 468
  20. [pid 23749] 15:54:41 poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=7, revents=POLLIN}])
  21. [pid 23749] 15:54:41 recvfrom(7, «1113323def5totalf?251020153376224016553762», 1415, MSG_DONTWAIT, NULL, NULL) = 60
  22. [pid 23749] 15:54:41 sendto(7, «32013SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = „1“ AND p.status = „1“ AND p.date_available <= NOW() AND p2s.store_id = „0“ AND cp.path_id = „348“», 468, MSG_DONTWAIT, NULL, 0) = 468
  23. [pid 23749] 15:54:41 poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=7, revents=POLLIN}])
  24. [pid 23749] 15:54:41 recvfrom(7, «1113323def5totalf?2510201533762340222553762», 1355, MSG_DONTWAIT, NULL, NULL) = 61
  25. [pid 23749] 15:54:41 sendto(7, «32013SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = „1“ AND p.status = „1“ AND p.date_available <= NOW() AND p2s.store_id = „0“ AND cp.path_id = „131“», 468, MSG_DONTWAIT, NULL, 0) = 468
  26.  
  27. Складывается ощущение, что при загрузке главной подгружаются все существующие на сайте товары и не по одному разу. Еще заметили, что блок категории при загрузке сразу выпадает - http://i.imgur.com/G2RLP1P.png , вероятно эти две проблемы связанны.

Share with your friends:

Print