Cris2014 Posted June 19, 2014 Share Posted June 19, 2014 Bonjour à tous, j'ai un problème avec ma boutique prestashop. Elle est devenue subitement très lente. Le BO fonctionne bien, mais la boutique en ligne non. Il faut environ 20 secondes pour un affichage!!!!! En attaché, le DEBUG... Quelqu'un a eu ce meme problème? Pouvez vous m'aider? Merci d'avance 26.562 ms SELECT SQL_NO_CACHE t.name, COUNT(pt.id_tag) AS times FROM `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE t.`id_lang` = 5 AND product_shop.`active` = 1 AND product_shop.`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` = 1 ) GROUP BY t.id_tag ORDER BY times DESC LIMIT 0, 15in /var/www/prestigeonline/classes/Tag.php:150USING FILESORT - 2474 rows browsed 26.099 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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_attribute` `pa` ON pa.`id_product` = p.`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) WHERE (p.`id_product` = 1099)in /var/www/prestigeonline/classes/Product.php:26281 row browsed 24.321 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1099 ORDER BY `id_specific_price_priority` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:1891 row browsed 9.864 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:28' >= `from` AND '2014-06-19 13:50:28' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1099) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:28' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:28' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 8.992 ms SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 1) AND c.`id_category` != 259 AND c.id_category IN (SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (2)) ORDER BY `level_depth` ASC, cs.`position` ASCin /var/www/prestigeonline/modules/blockcategories/blockcategories.php:174USING FILESORT - 160 rows browsed 5.008 ms SELECT SQL_NO_CACHE 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`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 90 DAY ) ) > 0 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` = 5 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` = 5 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 ( DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 90 DAY ) ) > 0) 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` = 1)) GROUP BY product_shop.id_product ORDER BY p.`date_add` DESC LIMIT 5in /var/www/prestigeonline/classes/Product.php:2052USING FILESORT - 7422 rows browsed 4.517 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)in /var/www/prestigeonline/classes/Configuration.php:116445 rows browsed 3.902 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.`id_group` IN (2)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`in /var/www/prestigeonline/classes/Hook.php:296USING FILESORT - 76 rows browsed 3.835 ms SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook` h INNER JOIN `ps_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.positionin /var/www/prestigeonline/classes/Hook.php:187USING FILESORT - 76 rows browsed 3.551 ms SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, ll.link, ll.label FROM ps_linksmenutop l LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 5 AND ll.id_shop=1) WHERE 1 AND l.id_linksmenutop = "1" AND l.id_shop IN (0, 1)in /var/www/prestigeonline/modules/blocktopmenu/menutoplinks.class.php:371 row browsed 3.461 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_hook_module` hm LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 63 LIMIT 1in /var/www/prestigeonline/classes/module/Module.php:15740 rows browsed 3.346 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, 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`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 90 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp 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_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 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 (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` ASC LIMIT 0,28in /var/www/prestigeonline/classes/Category.php:651USING FILESORT - 72 rows browsed 3.132 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1) as total FROM `ps_module` min /var/www/prestigeonline/classes/module/Module.php:16376 rows browsed 2.99 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_hook_module` hm LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 64 LIMIT 1in /var/www/prestigeonline/classes/module/Module.php:15740 rows browsed 2.963 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:2121 row browsed 2.903 ms SELECT SQL_NO_CACHE domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop=1 LIMIT 1in /var/www/prestigeonline/classes/shop/ShopUrl.php:1631 row browsed 2.744 ms SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 5) LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:2121 row browsed 2.673 ms SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.namein /var/www/prestigeonline/classes/shop/Shop.php:602USING FILESORT - 1 row browsed 2.636 ms SELECT SQL_NO_CACHE * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = 5 AND ml.id_shop = 1 LIMIT 1in /var/www/prestigeonline/classes/Meta.php:1411 row browsed 2.574 ms SELECT SQL_NO_CACHE pa.id_product_attribute 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) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 1099 LIMIT 1in /var/www/prestigeonline/classes/Product.php:6241 row browsed 2.517 ms SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1in /var/www/prestigeonline/classes/Image.php:3671 row browsed 2.498 ms SELECT SQL_NO_CACHE hm.`id_module` FROM `ps_hook_module` hm, `ps_hook` h WHERE hm.`id_module` = 63 AND h.`id_hook` = 9 AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1in /var/www/prestigeonline/classes/module/Module.php:6921 row browsed 2.242 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.prestigeonline.it' OR su.domain_ssl = 'www.prestigeonline.it') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESCin /var/www/prestigeonline/classes/shop/Shop.php:317USING FILESORT - 1 row browsed 2.201 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l INNER JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1in /var/www/prestigeonline/classes/Language.php:7744 rows browsed 2.056 ms SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1in /var/www/prestigeonline/classes/cache/CacheFs.php:361 row browsed 2.043 ms SELECT SQL_NO_CACHE pa.id_product_attribute 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) WHERE pa.id_product = 1099 LIMIT 1in /var/www/prestigeonline/classes/Product.php:6531 row browsed 1.843 ms SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 5 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 1099) AND (b.id_shop = 1) LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:2121 row browsed 1.824 ms SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)in /var/www/prestigeonline/classes/module/Module.php:15071 row browsed 1.782 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:11841 row browsed 1.764 ms SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 GROUP BY c.id_currency ORDER BY `name` ASCin /var/www/prestigeonline/classes/Currency.php:208USING FILESORT - 9 rows browsedUseless GROUP BY need to be removed 1.72 ms SELECT SQL_NO_CACHE `price_display_method` FROM `ps_group` WHERE `id_group` = 2 LIMIT 1in /var/www/prestigeonline/classes/Group.php:1361 row browsed 1.647 ms SELECT SQL_NO_CACHE domain FROM ps_shop_url WHERE main=1 AND id_shop = 1 LIMIT 1in /var/www/prestigeonline/classes/shop/ShopUrl.php:1511 row browsed 1.637 ms SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:2121 row browsed 1.617 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` = 'medium_likathebest' LIMIT 1in /var/www/prestigeonline/classes/ImageType.php:1370 rows browsed 1.558 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1in /var/www/prestigeonline/classes/shop/Shop.php:2001 row browsed 1.553 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 5 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 10) LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:2121 row browsed 1.543 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESCin /var/www/prestigeonline/classes/Dispatcher.php:426USING FILESORT - 25 rows browsed 1.52 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)in /var/www/prestigeonline/classes/Language.php:6702 rows browsed 1.502 ms SELECT SQL_NO_CACHE hm.`id_module` FROM `ps_hook_module` hm, `ps_hook` h WHERE hm.`id_module` = 64 AND h.`id_hook` = 9 AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1in /var/www/prestigeonline/classes/module/Module.php:6921 row browsed 1.496 ms SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 2in /var/www/prestigeonline/classes/ObjectModel.php:2192 rows browsed 1.471 ms SELECT SQL_NO_CACHE `iso_code` FROM `ps_country` WHERE `id_country` = 10 LIMIT 1in /var/www/prestigeonline/classes/Country.php:2201 row browsed 1.462 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`in /var/www/prestigeonline/classes/Hook.php:14286 rows browsed 1.449 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps_required_fieldin /var/www/prestigeonline/classes/ObjectModel.php:11432 rows browsed 1.435 ms SELECT SQL_NO_CACHE pa.id_product_attribute 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) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 1099 LIMIT 1in /var/www/prestigeonline/classes/Product.php:6441 row browsed 1.349 ms SELECT SQL_NO_CACHE * FROM ps_meta m LEFT JOIN ps_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'index' OR m.page='index') AND ml.id_lang = 5 AND ml.id_shop = 1 LIMIT 1in /var/www/prestigeonline/classes/Meta.php:1411 row browsed 1.32 ms SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 2) LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:2120 rows browsed 1.176 ms SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 0 AND image_shop.`cover` = 1 LIMIT 1in /var/www/prestigeonline/classes/Product.php:24111 row browsed 1.169 ms SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = 'paypal' LIMIT 1in /var/www/prestigeonline/classes/module/Module.php:15461 row browsed 1.168 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT 1in /var/www/prestigeonline/classes/Hook.php:1252 rows browsed 1.153 ms SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 5 AND id_shop = 1 LIMIT 1in /var/www/prestigeonline/classes/ObjectModel.php:11841 row browsed 1.038 ms SELECT SQL_NO_CACHE product_shop.id_product, 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_attribute` pa ON (product_shop.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) WHERE product_shop.`active` = 1 AND (( product_shop.`id_product` = 1996) OR( product_shop.`id_product` = 1504) OR( product_shop.`id_product` = 2346) OR( product_shop.`id_product` = 1099) OR( product_shop.`id_product` = 1153) ) 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` = 1 ) AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY RAND() LIMIT 1in /var/www/prestigeonline/classes/Product.php:2135USING FILESORT - 30 rows browsed 0.946 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:42' >= `from` AND '2014-06-19 13:50:42' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1490) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.916 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:41' >= `from` AND '2014-06-19 13:50:41' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 2262) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.894 ms SELECT SQL_NO_CACHE p.*, product_shop.*, stock.`out_of_stock` out_of_stock, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, p.`upc`, MAX(image_shop.`id_image`) id_image, il.`legend`, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 90 DAY)) > 0 AS new FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 AND pl.id_shop = 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_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` = 5) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE p.id_product = 1099 GROUP BY product_shop.id_product LIMIT 1in /var/www/prestigeonline/classes/Product.php:21591 row browsed 0.89 ms SELECT SQL_NO_CACHE image_shop.id_image, p.id_product, il.legend, product_shop.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite 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 (pl.id_product = p.id_product 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 (il.id_image = i.id_image) LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 ) WHERE p.id_product IN (549) AND pl.id_lang = 5 AND cl.id_lang = 5 GROUP BY product_shop.id_productin /var/www/prestigeonline/modules/blockviewed/blockviewed.php:1161 row browsedUseless GROUP BY need to be removed 0.889 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:42' >= `from` AND '2014-06-19 13:50:42' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1428) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.797 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:41' >= `from` AND '2014-06-19 13:50:41' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1153) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 5 rows browsed 0.757 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:41' >= `from` AND '2014-06-19 13:50:41' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 2356) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.756 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:42' >= `from` AND '2014-06-19 13:50:42' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1458) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.717 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:42' >= `from` AND '2014-06-19 13:50:42' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1486) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.691 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'taxManager' OR `name` = 'actionTaxManager' LIMIT 1in /var/www/prestigeonline/classes/Hook.php:1252 rows browsed 0.682 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:42' >= `from` AND '2014-06-19 13:50:42' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1408) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.676 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:41' >= `from` AND '2014-06-19 13:50:41' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1799) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:41' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.673 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:42' >= `from` AND '2014-06-19 13:50:42' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1405) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.653 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-19 13:50:42' >= `from` AND '2014-06-19 13:50:42' <= `to`, 1, 0) + IF (`id_group` = 2, 2, 0) + IF (`id_country` = 10, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (0, 1411) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 10) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-19 13:50:42' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1in /var/www/prestigeonline/classes/SpecificPrice.php:232USING FILESORT - 4 rows browsed 0.641 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` = 'likathebest_medium' LIMIT 1in /var/www/prestigeonline/classes/ImageType.php:137 Link to comment Share on other sites More sharing options...
Cris2014 Posted June 19, 2014 Author Share Posted June 19, 2014 Encore quelques info pour voir si on peut résoudre le problème :-) Load time: 10.882s You'd better run your shop on a toaster config: 35ms constructor: 0ms init: 9ms checkAccess: 0ms setMedia: 1ms postProcess: 0ms initHeader: 0ms initContent: 10.732s initFooter: 25ms display: 80ms Hook processing: 10.762s / 10.27 Mb displayRightColumn: 10.064s / 0.71 Mb displayLeftColumn: 340ms / 3.45 Mb displayHome: 273ms / 0.96 Mb displayHeader: 38ms / 3.87 Mb displayFooter: 25ms / 0.35 Mb displayTop: 16ms / 0.73 Mb moduleRoutes: 5ms / 0.19 Mb DisplayOverrideTemplate: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb Memory peak usage: 19.7 Mb config: 4.8 Mb constructor: 0 Mb init: 2.2 Mb checkAccess: 0 Mb setMedia: 0.11 Mb postProcess: 0 Mb initHeader: 0 Mb initContent: 9.74 Mb initFooter: 0.36 Mb display: 0.3 Mb Total cache size (in Cache class): 1.54 Mb DB type: DbPDO SQL Queries: 430 queries Time spent querying: 193ms Included files: 192 Size of included files: 2.21 Mb Globals (> 1 Ko only): 468 Ko _MODULES ≈ 209.1 Ko _LANG ≈ 166.4 Ko context ≈ 75.8 Ko _SERVER ≈ 7 Ko _MODULE ≈ 3.8 Ko _COOKIE ≈ 2.2 Ko Link to comment Share on other sites More sharing options...
JPresta.com Posted June 19, 2014 Share Posted June 19, 2014 (edited) Vous avez un module en colonne de droite qui ralenti votre boutique, essayez de savoir lequel il s'agit. Des tags peut-être? Edited June 19, 2014 by joemartin (see edit history) 1 Link to comment Share on other sites More sharing options...
Cris2014 Posted June 19, 2014 Author Share Posted June 19, 2014 joemartin.. par colonne de droite vous entendez celle que je vois à droite en regardant l'écran? Merci.... Link to comment Share on other sites More sharing options...
JPresta.com Posted June 19, 2014 Share Posted June 19, 2014 joemartin.. par colonne de droite vous entendez celle que je vois à droite en regardant l'écran? Merci.... Oui, les 10 secondes sont passées dedans: displayRightColumn: 10.064s Link to comment Share on other sites More sharing options...
Cris2014 Posted June 19, 2014 Author Share Posted June 19, 2014 Oui, les 10 secondes sont passées dedans: displayRightColumn: 10.064s Nous avons essayé d'enlever le module TAGS et mes préférés...mais ça ne change rien :-( Link to comment Share on other sites More sharing options...
Cris2014 Posted June 19, 2014 Author Share Posted June 19, 2014 Nous avons essayé d'enlever le module TAGS et mes préférés...mais ça ne change rien :-( Oui, les 10 secondes sont passées dedans: displayRightColumn: 10.064s Trouvé, ça doit etre le logo Paypal... Merci pour votre aide :-) 1 Link to comment Share on other sites More sharing options...
Cris2014 Posted June 19, 2014 Author Share Posted June 19, 2014 Trouvé le problème..nous avons du enlever le logo PayPal... et maintenant tout semble en ordre. Encore merci a joemartin! 1 Link to comment Share on other sites More sharing options...
Cris2014 Posted June 19, 2014 Author Share Posted June 19, 2014 Juste encore un précisation, Nous avons installé le module Paypal version 3.6.1 pour résoudre le probléme... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now