Дополнение для InstantMaps создает много запросов

 
Посетитель
no avatar
МедальАвторитет форума
Сообщений: 2795
На странице карточки объекта выдает 563 запроса. Вроде как это перебор для одной страницы. Может кто подскажет, как можно уменьшить их количество, ведь там нет такого количества инфомрации, чтобы совешалось такое количество запросов.
Посетитель
no avatar
МедальАвторитет форума
Сообщений: 2795
нашел причину. как решить с таким количеством запросов проблему

Код PHP:
  1. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=21 ORDER BY id ASC LIMIT 1
  2. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1"
  3. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344
  4. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=22 ORDER BY id ASC LIMIT 1
  5. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1"
  6. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344
  7. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=23 ORDER BY id ASC LIMIT 1
  8. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1"
  9. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344
  10. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=35 ORDER BY id ASC LIMIT 1
  11. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1"
  12. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344
  13. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=36 ORDER BY id ASC LIMIT 1
  14. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1"
  15. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344
  16. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=21 ORDER BY id ASC LIMIT 1
  17. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1"
  18. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344
  19. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=22 ORDER BY id ASC LIMIT 1
  20. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1"
  21. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344
  22. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=23 ORDER BY id ASC LIMIT 1
  23. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1"
  24. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344
  25. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=35 ORDER BY id ASC LIMIT 1
  26. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1"
  27. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344
  28. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=36 ORDER BY id ASC LIMIT 1
  29. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1"
  30. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344
  31. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=21 ORDER BY id ASC LIMIT 1
  32. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1"
  33. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344
  34. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=22 ORDER BY id ASC LIMIT 1
  35. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1"
  36. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344
  37. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=23 ORDER BY id ASC LIMIT 1
  38. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1"
  39. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344
  40. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=35 ORDER BY id ASC LIMIT 1
  41. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1"
  42. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344
  43. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=36 ORDER BY id ASC LIMIT 1
  44. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1"
  45. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344
  46. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=21 ORDER BY id ASC LIMIT 1
  47. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1"
  48. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344
  49. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=22 ORDER BY id ASC LIMIT 1
  50. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1"
  51. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344
  52. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=23 ORDER BY id ASC LIMIT 1
  53. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1"
  54. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344
  55. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=35 ORDER BY id ASC LIMIT 1
  56. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1"
  57. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344
  58. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=36 ORDER BY id ASC LIMIT 1
  59. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1"
  60. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344
  61. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=21 ORDER BY id ASC LIMIT 1
  62. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1"
  63. SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344
  64. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=22 ORDER BY id ASC LIMIT 1
  65. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1"
  66. SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344
  67. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=23 ORDER BY id ASC LIMIT 1
  68. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1"
  69. SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344
  70. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=35 ORDER BY id ASC LIMIT 1
  71. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1"
  72. SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344
  73. SELECT IFNULL(AVG(points), 0) as rating,user_id FROM cms_map_char_ratings WHERE item_id=344 AND id=36 ORDER BY id ASC LIMIT 1
  74. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1"
  75. SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344
и там еще порядка 600 подобных запросов ниже в карточке объекта
Реклама
cms
Посетитель
small user social cms
Медаль
Сообщений: 187
что именно создает такое количество запросов? таблица cms_map_char_ratings от куда?
InstantCMS Team
small user social cms
МедальКубок зрительских симпатийАвторитет форума
Сообщений: 1343
какое дополнение стоит?
в InstantMaps нет такой таблицы
В начало страницы
Предыдущая темаСледующая тема Перейти на форум:
Быстрый ответ
Чтобы писать на форуме, зарегистрируйтесь или авторизуйтесь.