Оптимизация запросов mySQL

[asorus]

Требуется оптимизация запросов к базе данных.
так как нагрузка на базу mySQL большая. Базу в связи с этим отрубают на время!
Посмотрите пожалуйста, может это хост такой (джино)

 

batstore . ru

[DangelZM]

Пишите в поддержку, просите у них лог самых тяжелых с вашего сайта запросов. Это сократит время в разы. Иначе нужно тречить самостоятельно, а это время и за частую за которое никто не готов платить. 

 

В принципе по вашему сайту у меня есть предположение. Могу посмотреть, пишите. 

[asorus]

Пишите в поддержку, просите у них лог самых тяжелых с вашего сайта запросов. Это сократит время в разы. Иначе нужно тречить самостоятельно, а это время и за частую за которое никто не готов платить. 

 

В принципе по вашему сайту у меня есть предположение. Могу посмотреть, пишите.

 

лог медленных из дминки jino

# Time: 131006 10:12:14 # User@Host: batstore[batstore] @ [10.0.0.13] # Thread_id: 18779497 Schema: batstore_jino Last_errno: 0 Killed: 0 # Query_time: 2.199902 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 use batstore_jino; SET timestamp=1381039934; DROP TABLE `address`, `affiliate`, `affiliate_transaction`, `attribute`, `attribute_description`, `attribute_group`, `attribute_group_description`, `banner`, `banner_image`, `banner_image_description`, `category`, `category_description`, `category_to_layout`, `category_to_store`, `country`, `coupon`, `coupon_history`, `coupon_product`, `currency`, `customer`, `customer_group`, `customer_group_description`, `customer_ip`, `customer_ip_blacklist`, `customer_online`, `customer_reward`, `customer_transaction`, `download`, `download_description`, `extension`, `geo_zone`, `information`, `information_description`, `information_to_layout`, `information_to_store`, `language`, `layout`, `layout_route`, `length_class`, `length_class_description`, `manufacturer`, `manufacturer_description`, `manufacturer_to_store`, `option`, `option_description`, `option_value`, `option_value_description`, `order`, `order_download`, `order_fraud`, `order_history`, `order_misc`, `order_option`, `order_product`, `order_status`, `order_total`, `order_voucher`, `product`, `product_attribute`, `product_description`, `product_discount`, `product_image`, `product_option`, `product_option_value`, `product_related`, `product_reward`, `product_special`, `product_tag`, `product_to_category`, `product_to_download`, `product_to_layout`, `product_to_store`, `return`, `return_action`, `return_history`, `return_reason`, `return_status`, `review`, `setting`, `simple_custom_data`, `stock_status`, `store`, `tax_class`, `tax_rate`, `tax_rate_to_customer_group`, `tax_rule`, `url_alias`, `user`, `user_group`, `voucher`, `voucher_history`, `voucher_theme`, `voucher_theme_description`, `weight_class`, `weight_class_description`, `zone`, `zone_to_geo_zone`; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 19077519 Schema: batstore_jino Last_errno: 1366 Killed: 0 # Query_time: 1.314706 Lock_time: 0.000115 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1 Rows_read: 0 # Bytes_sent: 13 use batstore_jino; SET timestamp=1381053748; INSERT INTO product SET model = '', sku = '', upc = '', ean = '', jan = '', isbn = '', mpn = '', location = '', quantity = '0', minimum = '0', subtract = '0', stock_status_id = '8', date_available = '', manufacturer_id = '1', shipping = '1', price = '590', points = '0', weight = '0', weight_class_id = '0', length = '0', width = '0', height = '0', length_class_id = '0', status = '1', tax_class_id = '', sort_order = '0', date_added = NOW(); # Time: 131008 0:21:47 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 22062317 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 2.395396 Lock_time: 0.000116 Rows_sent: 1000 Rows_examined: 10524095 Rows_affected: 0 Rows_read: 10524095 # Bytes_sent: 100480 use batstore; SET timestamp=1381177307; SELECT ua.keyword AS url_alias, pd.meta_keyword AS meta_keyword, pd.name AS name, p.price AS price, p.product_id AS product_id FROM product p LEFT JOIN url_alias ua ON (ua.query = CONCAT('product_id=', p.product_id)) LEFT JOIN product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') WHERE p.product_id GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 0,1000; # Time: 131008 0:22:22 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 22063025 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.813779 Lock_time: 0.000145 Rows_sent: 1000 Rows_examined: 7311764 Rows_affected: 0 Rows_read: 7311764 # Bytes_sent: 108938 SET timestamp=1381177342; SELECT ua.keyword AS url_alias, pd.meta_keyword AS meta_keyword, pd.name AS name, p.price AS price, p.product_id AS product_id FROM product p LEFT JOIN url_alias ua ON (ua.query = CONCAT('product_id=', p.product_id)) LEFT JOIN product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') WHERE p.product_id GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 1000,1000; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 22063406 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.096155 Lock_time: 0.000111 Rows_sent: 1000 Rows_examined: 4098433 Rows_affected: 0 Rows_read: 4098433 # Bytes_sent: 99965 use batstore; SET timestamp=1381177358; SELECT ua.keyword AS url_alias, pd.meta_keyword AS meta_keyword, pd.name AS name, p.price AS price, p.product_id AS product_id FROM product p LEFT JOIN url_alias ua ON (ua.query = CONCAT('product_id=', p.product_id)) LEFT JOIN product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') WHERE p.product_id GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 1000,1000; # Time: 131008 0:22:43 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 22063482 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.028160 Lock_time: 0.000134 Rows_sent: 1000 Rows_examined: 4099433 Rows_affected: 0 Rows_read: 4099433 # Bytes_sent: 113303 SET timestamp=1381177363; SELECT ua.keyword AS url_alias, pd.meta_keyword AS meta_keyword, pd.name AS name, p.price AS price, p.product_id AS product_id FROM product p LEFT JOIN url_alias ua ON (ua.query = CONCAT('product_id=', p.product_id)) LEFT JOIN product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') WHERE p.product_id GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 2000,1000; # Time: 131008 0:29:44 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 22071766 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 3.131906 Lock_time: 0.000149 Rows_sent: 3223 Rows_examined: 10526318 Rows_affected: 0 Rows_read: 10526318 # Bytes_sent: 496466 use batstore; SET timestamp=1381177784; SELECT p.product_id, (SELECT keyword FROM url_alias WHERE query = CONCAT( 'product_id=', p.product_id )) AS keyword, pd.name, p.model, m.name as manufacturer_name FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE pd.language_id = '1' ORDER BY pd.name ASC; # Time: 131008 0:57:41 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 22100629 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.760335 Lock_time: 0.000200 Rows_sent: 3213 Rows_examined: 5309395 Rows_affected: 0 Rows_read: 5309395 # Bytes_sent: 3085047 use batstore; SET timestamp=1381179461; SELECT DISTINCT p.product_id,REPLACE (pd.name, '"', '"') AS name,REPLACE (p.model, '"', '"') AS model,p.sku,p.ean,p.jan,p.isbn,p.mpn,p.upc,m.name AS manufacturer,p.shipping,p.location,TRUNCATE(p.price, 2) AS price,p.points,p.quantity,p.stock_status_id,p.length,p.width,p.height,p.weight,(SELECT su.keyword FROM `url_alias` su WHERE su.query = CONCAT('product_id=', p.product_id) LIMIT 1) AS keyword,pd.meta_keyword,pd.meta_description,pd.description,pd.tag,p.image,p.sort_order,p.status FROM product p LEFT JOIN `product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `manufacturer` m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN `product_to_category` p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND (p2c.category_id IN (3,16,19,30,7,12,6,29,27,8,1,14,5,9,10,22,17,13,23,4,11,26,31,28,2,15,18,25,24,20,21)) ORDER BY p.product_id LIMIT 0, 10000000; # Time: 131008 1:00:10 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 22103088 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 5.840873 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 use batstore; SET timestamp=1381179610; DROP TABLE `address`, `affiliate`, `affiliate_transaction`, `attribute`, `attribute_description`, `attribute_group`, `attribute_group_description`, `banner`, `banner_image`, `banner_image_description`, `category`, `category_description`, `category_to_layout`, `category_to_store`, `country`, `coupon`, `coupon_history`, `coupon_product`, `currency`, `customer`, `customer_group`, `customer_group_description`, `customer_ip`, `customer_ip_blacklist`, `customer_online`, `customer_reward`, `customer_transaction`, `download`, `download_description`, `extension`, `geo_zone`, `information`, `information_description`, `information_to_layout`, `information_to_store`, `language`, `layout`, `layout_route`, `length_class`, `length_class_description`, `manufacturer`, `manufacturer_description`, `manufacturer_to_store`, `option`, `option_description`, `option_value`, `option_value_description`, `order`, `order_download`, `order_fraud`, `order_history`, `order_misc`, `order_option`, `order_product`, `order_status`, `order_total`, `order_voucher`, `product`, `product_attribute`, `product_description`, `product_discount`, `product_image`, `product_option`, `product_option_value`, `product_related`, `product_reward`, `product_special`, `product_tag`, `product_to_category`, `product_to_download`, `product_to_layout`, `product_to_store`, `return`, `return_action`, `return_history`, `return_reason`, `return_status`, `review`, `setting`, `simple_custom_data`, `stock_status`, `store`, `tax_class`, `tax_rate`, `tax_rate_to_customer_group`, `tax_rule`, `url_alias`, `user`, `user_group`, `voucher`, `voucher_history`, `voucher_theme`, `voucher_theme_description`, `weight_class`, `weight_class_description`, `zone`, `zone_to_geo_zone`; # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 22103508 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.385495 Lock_time: 0.000087 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 use batstore; SET timestamp=1381179638; -- -------------------------------------------------------- -- -- Структура таблицы `order_total` -- CREATE TABLE IF NOT EXISTS `order_total` ( `order_total_id` int(10) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `code` varchar(32) NOT NULL, `title` varchar(255) NOT NULL DEFAULT '', `text` varchar(255) NOT NULL DEFAULT '', `value` decimal(15,4) NOT NULL DEFAULT '0.0000', `sort_order` int(3) NOT NULL, PRIMARY KEY (`order_total_id`), KEY `idx_orders_total_orders_id` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=686; # Time: 131010 3:07:53 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 26425028 Schema: batstore_jino Last_errno: 0 Killed: 0 # Query_time: 1.460569 Lock_time: 0.000094 Rows_sent: 1 Rows_examined: 21561 Rows_affected: 0 Rows_read: 21561 # Bytes_sent: 60 use batstore_jino; SET timestamp=1381360073; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '121'; # User@Host: batstore[batstore] @ [10.0.0.13] # Thread_id: 27971613 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.283867 Lock_time: 0.000125 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 use batstore; SET timestamp=1381422732; -- -------------------------------------------------------- -- -- Структура таблицы `order_voucher` -- CREATE TABLE IF NOT EXISTS `order_voucher` ( `order_voucher_id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `voucher_id` int(11) NOT NULL, `description` varchar(255) NOT NULL, `code` varchar(10) NOT NULL, `from_name` varchar(64) NOT NULL, `from_email` varchar(96) NOT NULL, `to_name` varchar(64) NOT NULL, `to_email` varchar(96) NOT NULL, `voucher_theme_id` int(11) NOT NULL, `message` text NOT NULL, `amount` decimal(15,4) NOT NULL, PRIMARY KEY (`order_voucher_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; # Time: 131011 2:06:38 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 28409675 Schema: batstore Last_errno: 1265 Killed: 0 # Query_time: 1.086223 Lock_time: 0.000037 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1 Rows_read: 0 # Bytes_sent: 13 use batstore; SET timestamp=1381442798; INSERT INTO product_description SET product_id = '9240', language_id = '1', name = 'Аккумулятор для Samsung AA-PB9MC6B, AA-PB9NC6B, AA-PB9NS6B', meta_keyword = '', meta_description = 'Аккумулятор (батарея) AA-PB9MC6B, AA-PB9NC6B, AA-PB9NS6B для ноутбука Samsung (NP) 300E, 300V, 305E, 305V, 350E, 350V, NP, P430, P510, P530, P580, Q230, Q320, R408, R425, R428, R429, R430, R463, R464, R465, R466, R647, R468, R469, R470, R478, R480, R517, R519, R520, R522, R525, R528, R530, R540, R580, R590, R620, R719, R720, R730, R780, RC410, RC510, RC530, RC710, RC730, RF410, RF510, RF710, RV400, RV500, RV700. Li-ion, 5200mAh, 11.1V, цвет черный. Аккумуляторные элементы Samsung. Совместимые модели: AA-PB9MC6B AA-PB9MC6S AA-PB9MC6W AA-PB9NC5B AA-PB9NC6B AA-PB9NC6W AA-PB9NC6W/E AA-PB9NL6B AA-PB9NL6W AA-PB9NS6B AA-PB9NS6W AA-PL9NC2B AA-PL9NC6B AA-PL9NC6W CL1296B.806', description = 'Аккумулятор (батарея) AA-PB9MC6B, AA-PB9NC6B, AA-PB9NS6B для ноутбука Samsung (NP) 300E, 300V, 305E, 305V, 350E, 350V, NP, P430, P510, P530, P580, Q230, Q320, R408, R425, R428, R429, R430, R463, R464, R465, R466, R647, R468, R469, R470, R478, R480, R517, R519, R520, R522, R525, R528, R530, R540, R580, R590, R620, R719, R720, R730, R780, RC410, RC510, RC530, RC710, RC730, RF410, RF510, RF710, RV400, RV500, RV700. Li-ion, 5200mAh, 11.1V, цвет черный. Аккумуляторные элементы Samsung. Совместимые модели: AA-PB9MC6B AA-PB9MC6S AA-PB9MC6W AA-PB9NC5B AA-PB9NC6B AA-PB9NC6W AA-PB9NC6W/E AA-PB9NL6B AA-PB9NL6W AA-PB9NS6B AA-PB9NS6W AA-PL9NC2B AA-PL9NC6B AA-PL9NC6W CL1296B.806', tag = '', seo_title = 'Аккумулятор для Samsung AA-PB9MC6B, AA-PB9NC6B, AA-PB9NS6B', seo_h1 = 'Аккумулятор для Samsung AA-PB9MC6B, AA-PB9NC6B, AA-PB9NS6B'; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 30566279 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.265094 Lock_time: 0.000076 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 1 # Bytes_sent: 52 use batstore; SET timestamp=1381527633; UPDATE product SET viewed = (viewed + 1) WHERE product_id = '1639'; # Time: 131012 1:58:21 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 30585011 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.023984 Lock_time: 0.000100 Rows_sent: 1 Rows_examined: 2 Rows_affected: 0 Rows_read: 2 # Bytes_sent: 195 use batstore; SET timestamp=1381528701; SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '8594' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name; # Time: 131012 2:11:50 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 30598940 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.250893 Lock_time: 0.000025 Rows_sent: 8687 Rows_examined: 8687 Rows_affected: 0 Rows_read: 8687 # Bytes_sent: 1802280 use batstore; SET timestamp=1381529510; SELECT * FROM `batstore`.`product`; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 33911874 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.928188 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 1 # Bytes_sent: 52 use batstore; SET timestamp=1381677774; UPDATE product SET viewed = (viewed + 1) WHERE product_id = '5490'; # Time: 131014 0:56:16 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 34393557 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 5.040137 Lock_time: 0.000042 Rows_sent: 98 Rows_examined: 98 Rows_affected: 0 Rows_read: 98 # Bytes_sent: 16101 use batstore; SET timestamp=1381697776; SHOW TABLE STATUS FROM `batstore`; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 35084092 Schema: batstore Last_errno: 1366 Killed: 0 # Query_time: 4.259669 Lock_time: 0.000084 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 1 # Bytes_sent: 52 use batstore; SET timestamp=1381734041; UPDATE product SET model = '001.01928', sku = '001.01928', upc = '', ean = '', jan = '', isbn = '', mpn = '', location = '', quantity = '0', minimum = '0', subtract = '0', stock_status_id = '8', date_available = '', manufacturer_id = '2', shipping = '1', price = '2690', points = '0', weight = '0', weight_class_id = '0', length = '0', width = '0', height = '0', length_class_id = '0', status = '1', tax_class_id = '', sort_order = '0', date_modified = NOW() WHERE product_id = '8923'; # Time: 131014 20:30:25 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 35916706 Schema: batstore Last_errno: 1366 Killed: 0 # Query_time: 1.571564 Lock_time: 0.000052 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 1 # Bytes_sent: 52 use batstore; SET timestamp=1381768225; UPDATE product SET model = '001.01960', sku = '001.01960', upc = '', ean = '', jan = '', isbn = '', mpn = '', location = '', quantity = '10', minimum = '0', subtract = '0', stock_status_id = '7', date_available = '', manufacturer_id = '1', shipping = '1', price = '2590', points = '0', weight = '0', weight_class_id = '0', length = '0', width = '0', height = '0', length_class_id = '0', status = '1', tax_class_id = '', sort_order = '0', date_modified = NOW() WHERE product_id = '425'; # Time: 131015 8:38:17 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 36648720 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.114609 Lock_time: 0.000035 Rows_sent: 98 Rows_examined: 98 Rows_affected: 0 Rows_read: 98 # Bytes_sent: 15577 use batstore; SET timestamp=1381811897; SHOW TABLE STATUS FROM `batstore`; # Time: 131015 21:43:56 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 37704893 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.491259 Lock_time: 0.000043 Rows_sent: 10222 Rows_examined: 10222 Rows_affected: 0 Rows_read: 10222 # Bytes_sent: 2136799 use batstore; SET timestamp=1381859036; SELECT * FROM `batstore`.`product`; # Time: 131015 21:43:58 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 37704893 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.843464 Lock_time: 0.000024 Rows_sent: 10222 Rows_examined: 10222 Rows_affected: 0 Rows_read: 10222 # Bytes_sent: 7133817 SET timestamp=1381859038; SELECT * FROM `batstore`.`product_description`; # Time: 131015 23:09:58 # User@Host: batstore[batstore] @ [10.0.0.13] # Thread_id: 37840703 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.607950 Lock_time: 0.000094 Rows_sent: 98 Rows_examined: 98 Rows_affected: 0 Rows_read: 98 # Bytes_sent: 14397 use batstore; SET timestamp=1381864198; SHOW TABLE STATUS FROM `batstore`; # Time: 131017 16:03:44 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 41336908 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.529578 Lock_time: 0.001900 Rows_sent: 1 Rows_examined: 30666 Rows_affected: 0 Rows_read: 30666 # Bytes_sent: 60 use batstore; SET timestamp=1382011424; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (741); # Time: 131017 22:52:28 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 42054740 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 2.697341 Lock_time: 0.000062 Rows_sent: 98 Rows_examined: 98 Rows_affected: 0 Rows_read: 98 # Bytes_sent: 15665 use batstore; SET timestamp=1382035948; SHOW TABLE STATUS FROM `batstore`; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 42166958 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.062081 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 1 # Bytes_sent: 11 use batstore; SET timestamp=1382040103; DELETE FROM product_to_category WHERE product_id = '9019'; # Time: 131018 4:57:54 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 42947084 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 3.448450 Lock_time: 0.052247 Rows_sent: 380 Rows_examined: 1960 Rows_affected: 0 Rows_read: 1960 # Bytes_sent: 505965 use batstore; SET timestamp=1382057874; SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name; # Time: 131018 13:36:44 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 43703985 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.028635 Lock_time: 0.000055 Rows_sent: 239 Rows_examined: 478 Rows_affected: 0 Rows_read: 478 # Bytes_sent: 10694 use batstore; SET timestamp=1382089004; SELECT * FROM country WHERE status = '1' ORDER BY name ASC; # Time: 131018 21:27:16 # User@Host: batstore[batstore] @ [10.0.0.13] # Thread_id: 44495651 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 2.545799 Lock_time: 0.000062 Rows_sent: 98 Rows_examined: 98 Rows_affected: 0 Rows_read: 98 # Bytes_sent: 15665 use batstore; SET timestamp=1382117236; SHOW TABLE STATUS FROM `batstore`; # Time: 131020 1:20:09 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 46784893 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.289828 Lock_time: 0.000106 Rows_sent: 1 Rows_examined: 30666 Rows_affected: 0 Rows_read: 30666 # Bytes_sent: 60 use batstore; SET timestamp=1382217609; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (736); # Time: 131021 12:11:54 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 49505057 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.611804 Lock_time: 0.000118 Rows_sent: 1 Rows_examined: 30343 Rows_affected: 0 Rows_read: 30343 # Bytes_sent: 60 use batstore; SET timestamp=1382343114; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (736); # Time: 131021 12:39:41 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 49555590 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.114952 Lock_time: 0.000185 Rows_sent: 1 Rows_examined: 30343 Rows_affected: 0 Rows_read: 30343 # Bytes_sent: 60 use batstore; SET timestamp=1382344781; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (734); # Time: 131021 12:44:59 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 49565487 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.129701 Lock_time: 0.013823 Rows_sent: 1 Rows_examined: 30343 Rows_affected: 0 Rows_read: 30343 # Bytes_sent: 60 use batstore; SET timestamp=1382345099; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (741); # Time: 131021 23:13:06 # User@Host: batstore[batstore] @ [10.0.0.9] # Thread_id: 50601537 Schema: batstore Last_errno: 1160 Killed: 0 # Query_time: 1.085434 Lock_time: 0.000024 Rows_sent: 7374 Rows_examined: 7374 Rows_affected: 0 Rows_read: 7374 # Bytes_sent: 1507328 use batstore; SET timestamp=1382382786; SELECT * FROM `batstore`.`product`; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 51666327 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.413782 Lock_time: 0.000142 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382428494; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (738); # Time: 131022 12:54:43 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 51768933 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.161824 Lock_time: 0.000145 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382432083; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (737); # Time: 131022 18:40:06 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 52363773 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.027767 Lock_time: 0.000166 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382452806; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (631); # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 52388983 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.161653 Lock_time: 0.000148 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382453710; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (641); # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 52388983 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.130433 Lock_time: 0.000224 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382453712; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (733); # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 52456112 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.489939 Lock_time: 0.000177 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382456016; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (739); # Time: 131022 20:54:09 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 52597747 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.490990 Lock_time: 0.000129 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382460849; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (738); # Time: 131023 14:25:35 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 54190783 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.255932 Lock_time: 0.000488 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382523935; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (737); # Time: 131023 19:33:44 # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 54724776 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.168934 Lock_time: 0.000103 Rows_sent: 1 Rows_examined: 30663 Rows_affected: 0 Rows_read: 30663 # Bytes_sent: 60 use batstore; SET timestamp=1382542424; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (736); # Time: 131023 21:37:17 # User@Host: batstore[batstore] @ [10.0.0.13] # Thread_id: 54929832 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 4.539976 Lock_time: 0.000068 Rows_sent: 98 Rows_examined: 98 Rows_affected: 0 Rows_read: 98 # Bytes_sent: 15665 use batstore; SET timestamp=1382549837; SHOW TABLE STATUS FROM `batstore`; # User@Host: batstore[batstore] @ [10.0.0.106] # Thread_id: 55172910 Schema: batstore Last_errno: 0 Killed: 0 # Query_time: 1.295956 Lock_time: 0.000351 Rows_sent: 1 Rows_examined: 30666 Rows_affected: 0 Rows_read: 30666 # Bytes_sent: 60 use batstore; SET timestamp=1382558730; SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (740);

Змінено 6 листопада 2013 користувачем afwollis
spoiler