#1
24 августа 2014 в 00:57
На странице карточки объекта выдает 563 запроса. Вроде как это перебор для одной страницы. Может кто подскажет, как можно уменьшить их количество, ведь там нет такого количества инфомрации, чтобы совешалось такое количество запросов.
#2
25 августа 2014 в 15:51
нашел причину. как решить с таким количеством запросов проблему
и там еще порядка 600 подобных запросов ниже в карточке объекта
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 SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=21 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=22 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=23 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=35 AND item_id = 344 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 SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344 AND user_id = "1" SELECT 1 FROM cms_map_char_ratings WHERE id=36 AND item_id = 344
#3
25 августа 2014 в 19:10
что именно создает такое количество запросов? таблица cms_map_char_ratings от куда?
Сегодня в 18:08
#4
25 августа 2014 в 20:15
какое дополнение стоит?
в InstantMaps нет такой таблицы
в InstantMaps нет такой таблицы