• -10%
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Tapete de Cozinha Tânia | Tapete de vinil lado a lado | Revitex
Rebajas

Tapete de cozinha Mendy Tania

Tapete de cozinha tipo vinil, com base em fibra e camada antirriscos.

Cores
  • Multicolorido
Medidas do tapete
Últimos artigos em stock
8,91 € 9,90 € -10%
Com IVA

 

Tania é um tapete de cozinha com um padrão de azulejo moderno e original, um tapete que será muito útil para evitar manchas de gordura no chão durante a cozedura.

Composição
76% Poliéster - 24% Algodão
Cuidado
Lavar a 30º. Não use água sanitária. Engomar a baixa temperatura. Sem lavagem a seco. Não use o secador.
8139-Mendy
Novo

3 outros produtos na mesma categoria:

Clientes que compraram este produto também compraram:

ENVÍO GRATUITO

Gratis a partir de 45€ (excepto Baleares) y recogida en tienda

DEVOLUCIONES

Dispones de 30 días para devolver tu compra

PAGO SEGURO

Tarjeta bancaria, trasferencia, Paypal y contra reembolso

ATENCIÓN AL CLIENTE

Tfno: 987 802 608. Whatsapp: 690 652 934 Lunes a viernes de 9:00-13:30 y 16:00-19:00

Product added to wishlist
Load Time 1968 ms
Querying Time 1734 ms
Queries 1222
Memory Peak Usage 45.0 Mb
Included Files 1432 files - 16.84 Mb
PrestaShop Cache - Mb
Global vars 0.80 Mb
PrestaShop Version 8.2.0
PHP Version 8.1.28
MySQL Version 5.7.44
Memory Limit 256M
Max Execution Time 30s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 9.530 ms 9.530 ms 5.61 Mb 5.7 Mb
__construct 0.016 ms 9.546 ms - Mb 5.7 Mb
init 79.700 ms 89.246 ms 2.96 Mb 8.6 Mb
checkAccess 0.002 ms 89.248 ms - Mb 8.6 Mb
setMedia 16.707 ms 105.955 ms 0.48 Mb 9.1 Mb
postProcess 0.027 ms 105.982 ms - Mb 9.1 Mb
initHeader 0.003 ms 105.985 ms - Mb 9.1 Mb
initContent 171.513 ms 277.498 ms 4.40 Mb 13.5 Mb
initFooter 0.002 ms 277.500 ms - Mb 13.5 Mb
display 1691 ms 1968 ms 30.39 Mb 45.0 Mb
Hook Time Memory Usage
displayFooterProduct 1497 ms 24.76 Mb
ActionProductPriceCalculation 247.664 ms 13.05 Mb
DisplayProductListReviews 87.431 ms 5.30 Mb
DisplayBeforeBodyClosingTag 48.906 ms 1.50 Mb
displayAfterBreadcrumb 45.618 ms 0.30 Mb
ActionFrontControllerSetMedia 15.571 ms 0.24 Mb
DisplayHeader 13.442 ms 0.83 Mb
DisplayAfterProductThumbs 11.682 ms 0.49 Mb
DisplayFooterProduct 6.503 ms 0.16 Mb
displayProductExtraContent 6.428 ms 0.04 Mb
DisplayProductAdditionalInfo 4.717 ms 0.21 Mb
displayNav2 3.915 ms 0.26 Mb
DisplayFooter 2.747 ms 0.16 Mb
displayProductAdditionalInfo 2.692 ms 0.19 Mb
displayProductListFunctionalButtons 2.533 ms 0.01 Mb
ActionObjectAddAfter 2.385 ms 0.11 Mb
displayProductVariants 2.208 ms 0.16 Mb
displayBeforeBodyClosingTag 2.194 ms 0.12 Mb
displayAfterProductThumbs 2.136 ms 0.07 Mb
displayFooter 1.867 ms 0.12 Mb
DisplayProductPriceBlock 1.802 ms 0.14 Mb
DisplayProductActions 1.579 ms 0.09 Mb
DisplayTop 1.297 ms 0.07 Mb
ModuleRoutes 1.281 ms 0.06 Mb
displayNav1 1.255 ms 0.07 Mb
renderWidget 1.053 ms 0.04 Mb
displayProductElementor 0.992 ms 0.06 Mb
DisplayNav1 0.945 ms 0.05 Mb
displayMainMenu 0.865 ms 0.23 Mb
displayCustomerLoginFormAfter 0.845 ms 0.06 Mb
Header 0.728 ms 0.04 Mb
DisplayProductExtraContent 0.697 ms 0.03 Mb
ActionDispatcher 0.560 ms - Mb
DisplayTrustbadge 0.560 ms 0.02 Mb
DisplayBanner 0.537 ms 0.02 Mb
DisplayWrapperBottom 0.526 ms 0.02 Mb
DisplayNav2 0.518 ms 0.02 Mb
displayAsFirstProductImage 0.493 ms 0.07 Mb
displayWrapperBottomInContainer 0.326 ms 0.03 Mb
displayAfterProductAddCartBtn 0.237 ms - Mb
displayTop 0.198 ms 0.01 Mb
DisplayPaCaptcha 0.164 ms 0.01 Mb
DisplayReassurance 0.080 ms - Mb
OverrideLayoutTemplate 0.072 ms - Mb
displayAsLastProductImage 0.021 ms - Mb
ActionDispatcherBefore 0.011 ms - Mb
DisplayOverrideTemplate 0.008 ms - Mb
DisplayNavFullWidth 0.005 ms - Mb
ActionFrontControllerAfterInit 0.005 ms - Mb
ActionFrontControllerInitAfter 0.003 ms - Mb
50 hook(s) 2025 ms 49.26 Mb
Module Time Memory Usage
klaviyopsautomation 1.622 ms - Mb
lgseoredirect 3.334 ms 0.09 Mb
prestablog 3.909 ms 0.56 Mb
storelocator 4.945 ms 0.56 Mb
ets_delete_order 0.878 ms 0.04 Mb
iqitthemeeditor 1.029 ms 0.11 Mb
trustedshopseasyintegration 7.191 ms 0.40 Mb
quantitydiscountpro 4.491 ms 0.32 Mb
sameprice 250.086 ms 13.31 Mb
motive 15.806 ms 0.26 Mb
ps_emailsubscription 1.046 ms 0.14 Mb
ps_emailalerts 0.159 ms 0.04 Mb
monei 0.184 ms 0.07 Mb
iqitadditionaltabs 5.939 ms 0.12 Mb
ph_relatedposts 2.830 ms 0.36 Mb
revsliderprestashop 2.824 ms 0.40 Mb
ps_shoppingcart 0.147 ms 0.02 Mb
psxmarketingwithgoogle 0.343 ms 0.03 Mb
ps_googleanalytics 4.514 ms 0.10 Mb
iqitcontactpage 0.931 ms 0.07 Mb
iqitelementor 1.671 ms 0.22 Mb
iqitfreedeliverycount 0.100 ms 0.02 Mb
iqitmegamenu 1.110 ms 0.29 Mb
iqitsizecharts 2.382 ms 0.21 Mb
iqitwishlist 5.814 ms 0.28 Mb
iqitextendedproduct 2.819 ms 0.19 Mb
iqitsociallogin 0.982 ms 0.08 Mb
whatsappchat 13.640 ms 0.74 Mb
advancedpopupcreator 2.924 ms 0.25 Mb
seosaproductlabels 96.398 ms 5.56 Mb
rcpgtagmanager 12.731 ms 0.76 Mb
codfee 3.245 ms 0.12 Mb
linkobfuscator 0.181 ms 0.01 Mb
ets_recaptcha_free 0.317 ms 0.04 Mb
probance_track 0.253 ms 0.02 Mb
probance_pnotif 0.125 ms 0.02 Mb
fspickupatstore 0.970 ms 0.31 Mb
paypal 2.965 ms 0.26 Mb
mdsmartpickup 0.187 ms 0.02 Mb
probance_coupons 0.266 ms 0.10 Mb
iqitlinksmanager 1.709 ms 0.09 Mb
ps_languageselector 2.238 ms 0.17 Mb
ps_currencyselector 0.586 ms 0.05 Mb
iqitsearch 1.264 ms 0.06 Mb
ps_customersignin 0.087 ms 0.02 Mb
pagesnotfound 0.094 ms 0.02 Mb
iqitproductsnav 45.740 ms 0.32 Mb
ps_sharebuttons 1.460 ms 0.09 Mb
iqitproducttags 1.004 ms 0.09 Mb
ps_viewedproduct 0.569 ms 0.06 Mb
ps_categoryproducts 754.393 ms 8.18 Mb
ps_crossselling 742.616 ms 16.62 Mb
statsdata 30.074 ms 0.45 Mb
lgproductordered 0.315 ms 0.04 Mb
dgtranslationall 2.590 ms 0.20 Mb
55 module(s) 2046 ms 52.97 Mb

Stopwatch SQL - 1222 queries

# Query Time (ms) Rows Filesort Group By Location
549
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (38375,38376,38377,38378,38379,38380,38381,38382,38383)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
212.074 ms 18 /classes/Product.php:2752
620
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 8143
AND pac.`id_product_attribute` = 41671
AND agl.`id_lang` = 2
82.520 ms 2 /classes/Product.php:7534
570
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
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)
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_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8142) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
71.415 ms 189 Yes Yes /classes/Product.php:4524
593
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
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)
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_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8138) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
56.181 ms 3 Yes Yes /classes/Product.php:4524
1137
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
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)
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_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5493) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
51.943 ms 210 Yes Yes /classes/Product.php:4524
598
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (40542,40543,40544,41671,41672,41673)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
46.668 ms 12 /classes/Product.php:2752
742
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 8254
AND pac.`id_product_attribute` = 40218
AND agl.`id_lang` = 2
45.413 ms 2 /classes/Product.php:7534
683
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 8253
AND pac.`id_product_attribute` = 40198
AND agl.`id_lang` = 2
41.575 ms 2 /classes/Product.php:7534
578
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (38343,38344,38345)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
40.424 ms 6 /classes/Product.php:2752
528
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 40542
AND cp.`id_cart` = 0 AND cp.`id_product` = 8143 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 40542
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8143 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
39.075 ms 0 /classes/Cart.php:1430
1143
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 5493
AND pac.`id_product_attribute` = 30143
AND agl.`id_lang` = 2
35.613 ms 2 /classes/Product.php:7534
866
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 6124
AND pac.`id_product_attribute` = 22932
AND agl.`id_lang` = 2
35.233 ms 2 /classes/Product.php:7534
156
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
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  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 8139
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND product_attribute_shop.`id_product_attribute` = 38348 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
31.819 ms 2 Yes Yes /classes/Product.php:4598
1109
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 8636
AND pac.`id_product_attribute` = 43061
AND agl.`id_lang` = 2
31.396 ms 2 /classes/Product.php:7534
65
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
27.833 ms 618 /classes/SpecificPrice.php:310
1147
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 5493
AND pac.`id_product_attribute` = 30145
AND agl.`id_lang` = 2
25.066 ms 2 /classes/Product.php:7534
804
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 1252
AND pac.`id_product_attribute` = 2114
AND agl.`id_lang` = 2
24.011 ms 2 /classes/Product.php:7534
618
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
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)
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_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8143) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
23.543 ms 126 Yes Yes /classes/Product.php:4524
575
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 8142
AND pac.`id_product_attribute` = 38375
AND agl.`id_lang` = 2
22.685 ms 2 /classes/Product.php:7534
1151
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 5493
AND pac.`id_product_attribute` = 30148
AND agl.`id_lang` = 2
19.469 ms 2 /classes/Product.php:7534
1069
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (22932)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
18.785 ms 2 /classes/Product.php:2752
314
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (38348,45326)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
17.682 ms 4 /classes/Product.php:2752
142
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` = 8139
16.820 ms 2 /classes/Product.php:7496
1107
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
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)
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_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8636) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
16.244 ms 3 Yes Yes /classes/Product.php:4524
312
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 8138
AND pac.`id_product_attribute` = 38344
AND agl.`id_lang` = 2
15.923 ms 2 /classes/Product.php:7534
1020
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (40218,40219,40220,40221)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
15.723 ms 8 /classes/Product.php:2752
1089
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (43061,43062,43063)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
15.428 ms 6 /classes/Product.php:2752