Cris2014

La versione che stiamo usando è 1.5.6.2. Qualcuno ha trovato il modo di risolvere questo problema o di capire da cosa è dovuto? Grazie a tutti!

Buongiorno a tutti, avevo già scritto qualcosa al riguardo, ma visto che non abbiamo ancora risolto, chiedo di nuovo aiuto. Sul nostro sito con Prestashop 1.5.6.2 abbiamo il seguente problema: quando un cliente sceglie il pagamento con paypal e paga con carta di credito perchè non ha un account paypal, il sistema non inserisce nel totale da pagare le spese di spedizione, In pratica, la persona paga con paypal solo la merce e ogni volta devo poi mandare richiesta di pagamento per le spese di spedizione. Con doppie spese a mio carico da parte di paypal... A qualcuno succede la stessa cosa? Un pò di tempo fa abbiamo contattato Paypal ma loro dicono che non dipende da loro... Secondo voi? Cosa può essere? Un grazie in anticipo a chi potrà aiutarci.

Ciao, pensavamo di aver risolto... ma ha funzionato solo per un ordine. Le uniche informazioni che abbiamo in più sono che sembra succede solo quando i clienti pagano con paypal ma usando carta di credito perché non hanno l'account. Se qualcuno trova una soluzione....ben venga! Ciaoooo

Bonjour à vous tous.. j'ai écrit dans le forum en italien..mais j'essaye de le faire aussi pour les francophones... Nous avons un problème avec certaines commandes. Les frais de livraison ne s'ajoutent pas au total de l'orde. Nous avons remarqué que ces commandes arrivent sans le canton et vu que les frais changent en fonction de l'adresse du client, prestashop ne peut les calculer. Le fait est que le canton ou province est un champ obligatoire pour pouvoir compléter la commande sinon il y a un message erreur. Je ne comprend pas comment se soit possible... en plus, si j'entre ds le BO ds le client je trouve, mise par default la première province dans l'ordre alfabetique, mais les frais de livraison relatifs à cette province ne viennent tout de meme pas calculés! pourriez-vous nous aider å comprendre ce qui se passe, vu que ce problėme ne se présente que sur certaines commandes? Merci d'avance...

Buongiorno a tutti, ho un problema con le spese di spedizione di alcuni ordini: capita che quando arrivano ordini con spedizione e corriere, prestashop non trasmette a paypal le spese di spedizione quindi mi arriva il pagamento senza spese e inoltre nel backoffice, nei dettagli dell ordine nella sezione spedizione rimane vuoto il campo data c'è solo tipo con scritto delivery la voce corriere e costo di spedizione rimangono vuoti... Il fatto è che succede solo con alcuni ordini, per esempio, gli ultimi due ordini arrivati a poche ore di distanza, uno è ok e all'altro mancano le spese di spedizione. L'unica cosa che hanno in comune questi ordini che danno problemi è che nell'indirizzo del cliente manca la provincia, anche se nel fare l'ordine, il campo provincia è un campo obbligatorio e non ti fa andare avanti. Probabilmente visto che le province non hanno sempre le stesse spese prestashop non riesce a calcolarle. Tutte le province sono collegate a zone (italia penisola e italia isole) e i corrieri sono disponibili per entrambe le zone. Quindi all'apparenza sembra tutto ok. Altra cosa che ho notato è che se entro nell'ordine per modificare l'indirizzo cliente, trovo come provincia, in tutti questi ordini con problema, Agrigento che è la prima dell'elenco a tendina. Come se non venisse selezionato nulla e per default nell'indirizzo mettesse la prima (Agrigento)..ma non calcola nemmeno le spese come se l'indirizzo cliente fosse ad Agrigento. Strana questa cosa.... A voi è mai successo? Cosa posso aver sbagliato? Grazie mille

Risolto, grazie Scusatemi, poco pratica!

Buongiorno a tutti, ho un problema con le spese di spedizione. A volte mi arrivano ordini senza le spese di spedizione calcolate e in questi stessi ordini non viene selezionato nemmeno il tipo di spedizione scelta. Così, il cliente fa l'ordine dei suoi articoli, arriva alla scelta del tipo di consegna (non capisco se riesce a selezionarlo e a me non me lo segna prestashop) e riesce ad andare avanti e a concludere l'ordine pagando con paypal solo il totale della merce, senza le spese di spedizione. A qualcuno di voi è mai successo? Qualcuno mi sa aiutare a risolvere? Grazie mille

Juste encore un précisation, Nous avons installé le module Paypal version 3.6.1 pour résoudre le probléme...

Trouvé le problème..nous avons du enlever le logo PayPal... et maintenant tout semble en ordre. Encore merci a joemartin!

Trouvé, ça doit etre le logo Paypal... Merci pour votre aide :-)

Nous avons essayé d'enlever le module TAGS et mes préférés...mais ça ne change rien :-(

joemartin.. par colonne de droite vous entendez celle que je vois à droite en regardant l'écran? Merci....

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

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, 15 in /var/www/prestigeonline/classes/Tag.php:150 USING 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:2628 1 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:189 1 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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` ASC in /var/www/prestigeonline/modules/blockcategories/blockcategories.php:174 USING 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 5 in /var/www/prestigeonline/classes/Product.php:2052 USING 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:116 445 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:296 USING 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.position in /var/www/prestigeonline/classes/Hook.php:187 USING 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:37 1 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 1 in /var/www/prestigeonline/classes/module/Module.php:1574 0 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,28 in /var/www/prestigeonline/classes/Category.php:651 USING 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` m in /var/www/prestigeonline/classes/module/Module.php:163 76 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 1 in /var/www/prestigeonline/classes/module/Module.php:1574 0 rows browsed 2.963 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1 in /var/www/prestigeonline/classes/ObjectModel.php:212 1 row browsed 2.903 ms SELECT SQL_NO_CACHE domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop=1 LIMIT 1 in /var/www/prestigeonline/classes/shop/ShopUrl.php:163 1 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 1 in /var/www/prestigeonline/classes/ObjectModel.php:212 1 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.name in /var/www/prestigeonline/classes/shop/Shop.php:602 USING 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 1 in /var/www/prestigeonline/classes/Meta.php:141 1 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 1 in /var/www/prestigeonline/classes/Product.php:624 1 row browsed 2.517 ms SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1 in /var/www/prestigeonline/classes/Image.php:367 1 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 1 in /var/www/prestigeonline/classes/module/Module.php:692 1 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)) DESC in /var/www/prestigeonline/classes/shop/Shop.php:317 USING 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 1 in /var/www/prestigeonline/classes/Language.php:774 4 rows browsed 2.056 ms SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1 in /var/www/prestigeonline/classes/cache/CacheFs.php:36 1 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 1 in /var/www/prestigeonline/classes/Product.php:653 1 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 1 in /var/www/prestigeonline/classes/ObjectModel.php:212 1 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:1507 1 row browsed 1.782 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 in /var/www/prestigeonline/classes/ObjectModel.php:1184 1 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` ASC in /var/www/prestigeonline/classes/Currency.php:208 USING FILESORT - 9 rows browsed Useless GROUP BY need to be removed 1.72 ms SELECT SQL_NO_CACHE `price_display_method` FROM `ps_group` WHERE `id_group` = 2 LIMIT 1 in /var/www/prestigeonline/classes/Group.php:136 1 row browsed 1.647 ms SELECT SQL_NO_CACHE domain FROM ps_shop_url WHERE main=1 AND id_shop = 1 LIMIT 1 in /var/www/prestigeonline/classes/shop/ShopUrl.php:151 1 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 1 in /var/www/prestigeonline/classes/ObjectModel.php:212 1 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 1 in /var/www/prestigeonline/classes/ImageType.php:137 0 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 1 in /var/www/prestigeonline/classes/shop/Shop.php:200 1 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 1 in /var/www/prestigeonline/classes/ObjectModel.php:212 1 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) DESC in /var/www/prestigeonline/classes/Dispatcher.php:426 USING 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:670 2 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 1 in /var/www/prestigeonline/classes/module/Module.php:692 1 row browsed 1.496 ms SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 2 in /var/www/prestigeonline/classes/ObjectModel.php:219 2 rows browsed 1.471 ms SELECT SQL_NO_CACHE `iso_code` FROM `ps_country` WHERE `id_country` = 10 LIMIT 1 in /var/www/prestigeonline/classes/Country.php:220 1 row browsed 1.462 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias` in /var/www/prestigeonline/classes/Hook.php:142 86 rows browsed 1.449 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps_required_field in /var/www/prestigeonline/classes/ObjectModel.php:1143 2 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 1 in /var/www/prestigeonline/classes/Product.php:644 1 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 1 in /var/www/prestigeonline/classes/Meta.php:141 1 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 1 in /var/www/prestigeonline/classes/ObjectModel.php:212 0 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 1 in /var/www/prestigeonline/classes/Product.php:2411 1 row browsed 1.169 ms SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = 'paypal' LIMIT 1 in /var/www/prestigeonline/classes/module/Module.php:1546 1 row browsed 1.168 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT 1 in /var/www/prestigeonline/classes/Hook.php:125 2 rows browsed 1.153 ms SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 5 AND id_shop = 1 LIMIT 1 in /var/www/prestigeonline/classes/ObjectModel.php:1184 1 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 1 in /var/www/prestigeonline/classes/Product.php:2135 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/Product.php:2159 1 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_product in /var/www/prestigeonline/modules/blockviewed/blockviewed.php:116 1 row browsed Useless 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING FILESORT - 4 rows browsed 0.691 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'taxManager' OR `name` = 'actionTaxManager' LIMIT 1 in /var/www/prestigeonline/classes/Hook.php:125 2 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/SpecificPrice.php:232 USING 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 1 in /var/www/prestigeonline/classes/ImageType.php:137

Rebonjour à tous! Depuis quelques jours j'ai un problème avec les descriptions des catégories et des sous-catégories, seulement avec les dernières que je crée, celles qui étaient déjà sauvées n'ont aucun problème. Voilà ce qui se passe: le controller qui s'occupe de sauver, dans le model et dans le db, les déscriptions des catégories et sous-catégories, ne nettoie plus le texte du code html e nous avons donc dans le front end, dans le alt des cat e sous-cat, du code html, ce qui n'est pas le top à la vue pour le visitateur et qui pourrait nous pénaliser pour le seo. Avez-vous une idée pour résoudre ce problème? Merci d'avance :-)