Тэги

Отладочная информация
Время выполнения: 48.019 с, из них

    * время инициализации необходимых модулей: 0.535 с;
    * время генерации содержания страницы: 47.789 с;
    * время соединения с СУБД: 0.003 с;
    * время выбора БД: 0.000 с;
    * время выполнения запросов: 46.894 с.

Использовано памяти: 11.76 Мб
Количество запросов: 101.
Компрессия: Отключена.
Кэширование: Отключено.


# Time: 090513  4:06:16
# User@Host: test[test] @ localhost []
# Query_time: 22  Lock_time: 0  Rows_sent: 539  Rows_examined: 446807
SELECT COUNT(tags_relation_table.tag_id) as count, tags_table.*
                 FROM tags_relation_table
                          
                 LEFT JOIN shop_items_catalog_table
                    ON tags_relation_table.shop_items_catalog_item_id = shop_items_catalog_table.shop_items_catalog_item_id
                 
                 LEFT JOIN tags_table
                    ON tags_relation_table.tag_id = tags_table.tag_id
                                         
                 WHERE shop_items_catalog_table.shop_shops_id = '9'
                  AND shop_items_catalog_table.shop_items_catalog_is_active = '1'
                           AND (shop_items_catalog_table.shop_items_catalog_putend_date >= '2009-05-13 04:05:54'
                           OR shop_items_catalog_table.shop_items_catalog_putend_date ='0000-00-00 00:00:00')
                           AND shop_items_catalog_table.shop_items_catalog_putoff_date <= '2009-05-13 04:05:54'
                 
                 
                 GROUP BY tags_relation_table.tag_id
                 HAVING count > 0
                 ORDER BY tags_table.tag_name ASC;




# Time: 090513  4:06:19
# User@Host: test[test] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 503  Rows_examined: 56491
SELECT shop_groups_id, count(shop_items_catalog_item_id) as count
                 FROM shop_items_catalog_table
                 WHERE `shop_shops_id` = '9'
                 AND `shop_items_catalog_modification_id` = 0
                  AND shop_items_catalog_table.shop_items_catalog_is_active = '1'
                           AND (shop_items_catalog_table.shop_items_catalog_putend_date >= '2009-05-13 04:06:16'
                           OR shop_items_catalog_table.shop_items_catalog_putend_date ='0000-00-00 00:00:00')
                           AND shop_items_catalog_table.shop_items_catalog_putoff_date <= '2009-05-13 04:06:16'
                 GROUP BY shop_groups_id;




# Time: 090513  4:06:40
# User@Host: test[test] @ localhost []
# Query_time: 21  Lock_time: 0  Rows_sent: 84  Rows_examined: 665844
SELECT * FROM shop_properties_items_table, shop_list_of_properties_table
                           WHERE shop_properties_items_table.shop_items_catalog_item_id IN (4280,4407,8342,8766,16562,27153,27303)
                           AND shop_properties_items_table.shop_list_of_properties_id = shop_list_of_properties_table.shop_list_of_properties_id
                           ORDER BY shop_list_of_properties_table.shop_list_of_properties_order;