Stopwatch (with SQL_NO_CACHE) (total = 9016)
363.266 ms SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, MAX(image_shop.`id_image`) id_image, il.legend, m.name manufacturer_name, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 10 DAY)) > 0 AS new, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity 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` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND c.nleft >= 47 AND c.nright <= 146 AND c.active = 1 AND p.id_product IN (8,28,29,31,32,33,34,35,37,38,39,40,41,44,46,47,51,52,53,54,55,71,72,73,74,75,76,87,88,89,90,135,136,138,139,140,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,208,209,210,211,212,213,214,215,227,228,229,230,231,232,233,235,238,239,241,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,260,261,262,263,264,265,266,267,268,269,270,271,274,276,277,278,279,280,281,284,285,286,289,295,298,300,301,302,303,307,308,310,311,313,315,316,317,343,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,569,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,597,598,599,600,601,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,620,621,622,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,669,670,671,672,673,674,675,676,677,678,679,680,681,682,684,685,686,687,689,690,691,692,693,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869) GROUP BY product_shop.id_product ORDER BY cp.position asc LIMIT 0,522
in /modules/blocklayered/blocklayered.php:2017
USING FILESORT - 1690 rows browsed
69.266 ms SELECT p.`id_product` id_product FROM `ps_product` p 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 >= 47 AND c.nright <= 146 AND c.active = 1) RIGHT JOIN ps_layered_category lc ON (lc.id_category = 17 AND lc.id_shop = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product
in /modules/blocklayered/blocklayered.php:2028
USING FILESORT - 25200 rows browsed
Useless GROUP BY need to be removed
68.649 ms SELECT p.`id_product` id_product FROM `ps_product` p 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 >= 47 AND c.nright <= 146 AND c.active = 1) RIGHT JOIN ps_layered_category lc ON (lc.id_category = 17 AND lc.id_shop = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY id_product
in /modules/blocklayered/blocklayered.php:2028
USING FILESORT - 25200 rows browsed
Useless GROUP BY need to be removed
65.233 ms SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, product_shop.`date_add` > "2014-09-16" as new, MAX(product_attribute_shop.id_product_attribute) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image` `i` ON i.`id_product` = p.`id_product` LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` `il` ON i.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT OUTER JOIN `ps_product_attribute` pa ON p.`id_product` = pa.`id_product` LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.default_on = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2014-09-16") AND (p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (3) ) )) GROUP BY product_shop.id_product ORDER BY p.`date_add` DESC LIMIT 16
in /classes/Product.php:2111
USING FILESORT - 1016 rows browsed
29.632 ms SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m.name, psi.price_min, psi.price_max FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_category_product cp ON (cp.id_product = p.id_product) INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 47 AND c.nright <= 146 AND c.active = 1) LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop = 1) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY p.id_product
in /modules/blocklayered/blocklayered.php:2309
USING FILESORT - 1600 rows browsed
Useless GROUP BY need to be removed
27.459 ms SELECT pa.id_product, a.color, pac.id_product_attribute, SUM(IF(stock.quantity > 0, 1, 0)) qty FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 ) JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = product_attribute_shop.id_product_attribute) JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) JOIN ps_attribute_group ag ON (ag.id_attribute_group = ag.id_attribute_group) WHERE pa.id_product IN (71,72,73,74,8,75,76,28,87,29,88,89,31,90,32,33,34,35,37,38,39,40,41,44,46,47,51,52,53,54,55,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,135,191,136,192,193,138,194,139,195,140,196,197,856,198,867,199,868,200,201,202,203,204,205,206,208,209,210,211,212,213,214,215,227,228,229,230,231,232,233,235,238,239,241,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,857,858,859,860,861,862,863,864,865,866,869) AND ag.is_color_group = 1 GROUP BY pa.id_product, color HAVING qty > 0
in /classes/Product.php:3121
USING FILESORT - 9790 rows browsed
26.886 ms SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m.name, psi.price_min, psi.price_max FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_category_product cp ON (cp.id_product = p.id_product) INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 47 AND c.nright <= 146 AND c.active = 1) LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop = 1) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY p.id_product
in /modules/blocklayered/blocklayered.php:2309
USING FILESORT - 1600 rows browsed
Useless GROUP BY need to be removed
26.092 ms SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , psi.price_min, psi.price_max FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_category_product cp ON (cp.id_product = p.id_product) INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 47 AND c.nright <= 146 AND c.active = 1) LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop = 1) INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY p.id_product
in /modules/blocklayered/blocklayered.php:2309
USING FILESORT - 1600 rows browsed
Useless GROUP BY need to be removed
25.39 ms SELECT COUNT(DISTINCT p.id_product) nbr, lpa.id_attribute_group, a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group, liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title, m.name, psi.price_min, psi.price_max FROM ps_layered_product_attribute lpa INNER JOIN ps_attribute a ON a.id_attribute = lpa.id_attribute INNER JOIN ps_attribute_lang al ON al.id_attribute = a.id_attribute AND al.id_lang = 1 INNER JOIN ps_product as p ON p.id_product = lpa.id_product INNER JOIN ps_attribute_group ag ON ag.id_attribute_group = lpa.id_attribute_group INNER JOIN ps_attribute_group_lang agl ON agl.id_attribute_group = lpa.id_attribute_group AND agl.id_lang = 1 LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1) WHERE a.id_attribute_group = 1 AND lpa.`id_shop` = 1 AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN ( SELECT id_product FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 47 AND c.nright <= 146 AND c.active = 1) ) GROUP BY lpa.id_attribute ORDER BY ag.`position` ASC, a.`position` ASC
in /modules/blocklayered/blocklayered.php:2309
USING FILESORT - 11360 rows browsed
24.356 ms SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_category_product cp ON (cp.id_product = p.id_product) INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 47 AND c.nright <= 146 AND c.active = 1) LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop = 1) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY p.id_product
in /modules/blocklayered/blocklayered.php:2309
USING FILESORT - 1800 rows browsed
Useless GROUP BY need to be removed
9.124 ms SELECT COUNT(DISTINCT p.id_product) nbr, lpa.id_attribute_group, a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group, liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title, m.name, psi.price_min, psi.price_max FROM ps_layered_product_attribute lpa INNER JOIN ps_attribute a ON a.id_attribute = lpa.id_attribute INNER JOIN ps_attribute_lang al ON al.id_attribute = a.id_attribute AND al.id_lang = 1 INNER JOIN ps_product as p ON p.id_product = lpa.id_product INNER JOIN ps_attribute_group ag ON ag.id_attribute_group = lpa.id_attribute_group INNER JOIN ps_attribute_group_lang agl ON agl.id_attribute_group = lpa.id_attribute_group AND agl.id_lang = 1 LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1) WHERE a.id_attribute_group = 3 AND lpa.`id_shop` = 1 AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN ( SELECT id_product FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 47 AND c.nright <= 146 AND c.active = 1) ) GROUP BY lpa.id_attribute ORDER BY ag.`position` ASC, a.`position` ASC
in /modules/blocklayered/blocklayered.php:2309
USIА дальше тонны такого только зеленого, а это красное
