в файле по длинным запросом выдает вот это но для меня это китайская грамота:
/usr/sbin/mysqld, Version: 5.5.35-0+wheezy1-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
# Time: 150205 4:09:39
#
User@Host: lustravik[lustravik] @ localhost []
# Query_time: 4.109312 Lock_time: 0.000189 Rows_sent: 3 Rows_examined: 28739840
use lustravik;
SET timestamp=1423098579;
SELECT id_product
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) n
WHERE n.row_number>=
(SELECT (row_number-MOD(row_number-1,3))
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) x
WHERE `id_product`=1850)
LIMIT 3;
/usr/sbin/mysqld, Version: 5.5.35-0+wheezy1-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
/usr/sbin/mysqld, Version: 5.5.35-0+wheezy1-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
# Time: 150205 4:50:43
#
User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 5.587938 Lock_time: 0.000243 Rows_sent: 0 Rows_examined: 768
SET timestamp=1423101043;
select count(*) into @discard from `information_schema`.`PARTITIONS`;
# Time: 150205 4:50:56
#
User@Host: lustravik[lustravik] @ localhost []
# Query_time: 4.215928 Lock_time: 0.000156 Rows_sent: 16 Rows_examined: 62771
use lustravik;
SET timestamp=1423101056;
SELECT p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` manufacturer_name,
tl.`name` tax_name, t.`rate`, cl.`name` category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(),
INTERVAL 20 DAY)) > 0 new
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p ON (p.`id_product` = cp.`id_product`)
LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1)
LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 6)
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 6)
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 6)
LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 177 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 6)
LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE cp.`id_category` = 2 AND p.`active` = 1
ORDER BY RAND() LIMIT 0, 16;
# Time: 150205 5:53:23
#
User@Host: lustravik[lustravik] @ localhost []
# Query_time: 4.408716 Lock_time: 0.000105 Rows_sent: 3 Rows_examined: 50460830
SET timestamp=1423104803;
SELECT id_product
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) n
WHERE n.row_number>=
(SELECT (row_number-MOD(row_number-1,3))
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) x
WHERE `id_product`=12861)
LIMIT 3;
# Time: 150205 8:33:27
#
User@Host: lustravik[lustravik] @ localhost []
# Query_time: 3.033531 Lock_time: 0.000148 Rows_sent: 3 Rows_examined: 40883750
SET timestamp=1423114407;
SELECT id_product
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) n
WHERE n.row_number>=
(SELECT (row_number-MOD(row_number-1,3))
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) x
WHERE `id_product`=35112)
LIMIT 3;
# Time: 150205 8:33:30
#
User@Host: lustravik[lustravik] @ localhost []
# Query_time: 3.202182 Lock_time: 0.000166 Rows_sent: 3 Rows_examined: 45931130
SET timestamp=1423114410;
SELECT id_product
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) n
WHERE n.row_number>=
(SELECT (row_number-MOD(row_number-1,3))
FROM
(SELECT `id_product`, @curRow := @curRow + 1 AS row_number
FROM `ps_product` p
JOIN
(SELECT @curRow := 0) r
WHERE `id_category_default`=2 AND active=1) x
WHERE `id_product`=26370)
LIMIT 3;
# Time: 150205 8:42:47
#
User@Host: lustravik[lustravik] @ localhost []
# Query_time: 20.363772 Lock_time: 0.000396 Rows_sent: 1098 Rows_examined: 8479196
SET timestamp=1423114967;
SELECT p.`id_product` id_product
FROM `ps_product` p
INNER JOIN `ps_layered_price_index` psi
ON
(
psi.price_min >= 1400
AND psi.price_max <= 1143837
AND psi.`id_product` = p.`id_product`
AND psi.`id_currency` = 4
)
INNER JOIN ps_category_product cp
ON p.id_product = cp.id_product
INNER JOIN ps_category c ON (c.id_category = cp.id_category AND
c.nleft >= 2
AND c.nright <= 29
AND c.active = 1)
WHERE 1 AND p.`active` = 1 AND p.id_manufacturer IN (16) AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 217056) GROUP BY id_product;
# Time: 150205 8:44:04
#
User@Host: lustravik[lustravik] @ localhost []
# Query_time: 13.856936 Lock_time: 0.002260 Rows_sent: 52 Rows_examined: 112319
SET timestamp=1423115044;
SELECT p.*, p.id_category_default, pl.*, i.id_image, il.legend, m.name manufacturer_name,
DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new
FROM `ps_category_product` cp
LEFT JOIN ps_category c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product)
LEFT JOIN ps_image i ON (i.id_product = p.id_product AND i.cover = 1)
LEFT JOIN ps_image_lang il ON (i.id_image = il.id_image AND il.id_lang = 6)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
WHERE p.`active` = 1 AND
c.nleft >= 2
AND c.nright <= 29
AND c.active = 1
AND pl.id_lang = 6
AND p.id_product IN
